954,566 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Trouble with setting up server

Running Win2kpro with mysql server 4.1. I installed the service "mysqld-max-nt.exe", but it won't run. It's set for automatic, but even if I try to activate it manually, it won't. I checked the event viewer and it shows only this:
"The mysql41 service terminated unexpectedly"
Could there be a problem with my config file?

my.cnf

[mysqld]
prompt = mysql\\_\v>\\_
port = 3306 
basedir = C:/MySQL/MySQLServer41/
datadir = C:/MySQL/storage/data/
innodb_data_home_dir = C:/MySQL/storage/data/ibdata/ 
innodb_log_group_home_dir = C:/MySQL/storage/data/iblogs/ 
innodb_data_file_path = ibdata1:10M:autoextend 
# Make table names case sensitive. 
set-variable = lower_case_table_names=0

I was following the tutorial here: http://www.analysisandsolutions.com/code/mybasic.htm#start



When I try to connect from the prompt, I get the error code 10061.

Also, the tutorial doesn't explain what InnoDB tables are. What's the difference with them?

Phaelax
Practically a Posting Shark
858 posts since Mar 2004
Reputation Points: 92
Solved Threads: 51
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You