Skip to Content
It is currently April 21st, 2018, 9:29 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 
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.


Reply with quote  
PostPosted: March 29th, 2010, 3:17 pm 

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
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.

Reply with quote  
PostPosted: April 3rd, 2010, 6:22 am 
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.

# 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

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

# The MySQL server
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_log_arch_dir = c:\iblogs
#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


set-variable = max_allowed_packet=16M


set-variable= key=16M

#help_file= c:\mysql\sql_client\
#client_file= c:\mysql\MySQL.options
#database = test
#queries_root= c:\mysql\queries
#last_database_file= c:\mysql\lastdb


Reply with quote  
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 7 guests

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