Skip to Content
It is currently November 28th, 2014, 3:17 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: MySQL - SAM won't open
PostPosted: March 29th, 2010, 2:48 pm 
Offline
New User
New User

Joined: January 18th, 2010, 11:22 am
Posts: 13
Location: Palmer Lake, CO
Well, I'm taking everyones advice and switching my site over to PHP.

I installed MySQL (and followed the instructions for setting it up) and SAM on a new computer. For some reason, when I try to open SAM, it says it cannot find the database.

I am using SAM 4.6 and MySQL 5 on a windows 7 platform.

I searched the forums, but didn't find anything that helped. Any ideas what I may be missing?

I am a bit confused on the order of install. The instructions I found on here said to install and set up MySQL first, then SAM. But you have to click on the SAMDB during the set up, and can't do that without SAM installed. So I think my problem might be in me setting up the "root" username when I installed SAM...but I don't know.

Any help would be awesome.

Dave


Top
 Profile  
 
PostPosted: March 29th, 2010, 3:17 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12212
Location: Show Low, AZ
Be sure SAM and MYSQL are both running as ADMIN.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
 
PostPosted: April 3rd, 2010, 6:22 am 
Offline
Super User
Super User

Joined: March 4th, 2005, 1:04 pm
Posts: 876
Location: The Edge of reality
As I use a package that installs php, mysql, apache etc my mysql is not in a 'normal' place so use a 'my' file in the root of your C drive you can check this out with a google search but heres mine if it helps.

Code:
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
default-character-set=latin1
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = flush_time=1800

# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = C:/phpdev5/mysql/
datadir = C:/phpdev5/mysql/data/

# Uncomment the following rows if you are using InnoDB tables
# Create the directories ibdata and iblogs before to start the server.
# If necessary, modify the size of the files

#innodb_data_file_path = ibdata1:200M
#innodb_data_home_dir = c:\ibdata
#set-variable = innodb_mirrored_log_groups=1
#innodb_log_group_home_dir = c:\iblogs
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=30M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = c:\iblogs
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=80M
#set-variable=lower_case_table_names =0
#set-variable = innodb_additional_mem_pool_size=10M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

# Uncomment the following row if you are using a Max server and you don't want the
# InnoDb tables

#skip-innobd

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key=16M

[client_fltk]
#help_file= c:\mysql\sql_client\MySQL.help
#client_file= c:\mysql\MySQL.options
#history_length=20
#database = test
#queries_root= c:\mysql\queries
#last_database_file= c:\mysql\lastdb

_________________
Image


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group