# What is wrong with my syntax? (MYSQL)
**URL:** https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439
**Category:** Factual Questions
**Created:** [April 2, 2002, 7:12pm UTC](https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439 "2002-04-02T19:12:27Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Clever\_Hans](https://boards.straightdope.com/u/Clever_Hans)
#### Post date: [April 2, 2002, 7:12pm UTC](https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439/1 "2002-04-02T19:12:27Z")
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](http://www.innodb.com/ibman.html#Creating_an_InnoDB_database)
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.innodb.com/ibman.html#Creating_an_InnoDB_database)
[http://www.mysql.com/documentation/mysql/bychapter/manual\_Installing.html#Windows\_server\_first\_start](http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Windows_server_first_start)
[http://www.vbulletin.com/manual/mysql.html](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
---
### Author:  [@Boobka](https://boards.straightdope.com/u/Boobka)
#### Post date: [April 2, 2002, 7:42pm UTC](https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439/2 "2002-04-02T19:42:21Z")
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.
---
### Author:  [@scotth](https://boards.straightdope.com/u/scotth)
#### Post date: [April 2, 2002, 8:22pm UTC](https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439/3 "2002-04-02T20:22:10Z")
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.
---
### Author:  [@scotth](https://boards.straightdope.com/u/scotth)
#### Post date: [April 2, 2002, 8:26pm UTC](https://boards.straightdope.com/t/what-is-wrong-with-my-syntax-mysql/101439/4 "2002-04-02T20:26:09Z")
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.