What is wrong with my syntax? (MYSQL)

Factual Questions
1

I hate not being able to figure something out, it truly bothers me. I have searched far and wide, short and narrow, low and behold, and nary an answer have I found. Well enough of the preamble here is my problem.

I have installed MYSQL as a service running on Windows 2k, I get the following errors when trying to open the server. I tried using a preset from here

C:\mysql\bin>mysql
ERROR 2003: Can’t connect to MySQL server on ‘localhost’ (10061)

C:\mysql\bin>mysqld-max --standalone
InnoDB: syntax error in innodb_data_file_path
020402 12:01:33 Can’t init databases

C:\mysql\bin>mysqld --standalone --debug
InnoDB: syntax error in innodb_data_file_path
020402 11:57:50 Can’t init databases

I know what you are thinking, debug is really helpful. Here is my cnf file.

[Client]
host = localhost
password = ****
#port=3306
#socket=MySQL

[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

basedir = c:\mysql
datadir = c:\mysql\data\

innodb_data_file_path = /ibdata/ibdata1:2000M;
innodb_data_home_dir = c:\ibdata
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
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

[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

and the following are the resources I have been using.

http://www.innodb.com/ibman.html#Creating_an_InnoDB_database

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Windows_server_first_start

http://www.vbulletin.com/manual/mysql.html

as well as a few message boards that I did not find overly helpful. I would have posted on those but similar posts had been ignored. So I says to myself, Bob (that’s what I call myself, it’s short for Justin) you have access to some of the brightest people on the planet thru the SDMB I’m sure they will be courteous enough to at least answer. [/end gratuitous sucking up in the hopes of an answer] So TMs any ideas, suggestions, archaic profane referenceswill be useful. Thanks in advance

Clever Hans: MYSQL MYASS

2

hmm I would have to check my settings at home (i am at work right now) but off the top of my head.

Make sure that localhost is defined in your hosts file, or actually use the localhost ip 127.0.0.1

That’s a good place to start.

3

I don’t run MySql, but here goes…

What I’ve noticed:

ERROR 2003: Can’t connect to MySQL server on ‘localhost’ (10061)

#port=3306

port=3306

Ok, the error indicates it is trying to connect on port 10061 (thats how I would read it anyway)

“#” usually indicates a comment. This is in the client section, and I would assume with that line “commented out” it uses the default port for the client. Presumably 10061?

The port=3306 in the MySql section would make me think the server is listening on 3306.

Things to try.

  1. Remove the “#” from the port line in the client section.
  2. OR change 3306 to 10061 in the MYSQL section.

Hope that helps.

4

And noticed one more line:

innodb_data_file_path = /ibdata/ibdata1:2000M;

I notice that all the other path delimiters are “” instead of “/” as in this line. Might try changing to “”.

Also, no other line has a “;” end of line marker. Might try deleting that.