meade470
asked on
Error 2003: Can't connect to MySQL server on 'localhost' (10061)
Hi all,
I'm trying to use MySQL to log data from Snort, but I can't get MySQL to work. When I enter mysql.exe, I receive the following error:
Error 2003: Can't connect to MySQL server on 'localhost' (10061)
Here's my my.ini:
[mysqld]
basedir=C:\EagleX\MySQL
bind-address=127.0.0.1
datadir=C:\EagleX\MySQL\da ta
skip-innodb
#language=C:\EagleX\MySQL\ share\your language directory
#slow query log#=
#tmpdir#=
port=7788
#set-variable=key_buffer=1 6M
[WinMySQLadmin]
Server=C:/EagleX/MySql/bin /mysqld-nt .exe
user=*****
password*******
QueryInterval=10
Any suggestions would be greatly appreciated!!!
I'm trying to use MySQL to log data from Snort, but I can't get MySQL to work. When I enter mysql.exe, I receive the following error:
Error 2003: Can't connect to MySQL server on 'localhost' (10061)
Here's my my.ini:
[mysqld]
basedir=C:\EagleX\MySQL
bind-address=127.0.0.1
datadir=C:\EagleX\MySQL\da
skip-innodb
#language=C:\EagleX\MySQL\
#slow query log#=
#tmpdir#=
port=7788
#set-variable=key_buffer=1
[WinMySQLadmin]
Server=C:/EagleX/MySql/bin
user=*****
password*******
QueryInterval=10
Any suggestions would be greatly appreciated!!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When I type this at the command line:
mysqld-nt --console
It tells me that its: "Ready for connections."
If that is what you got as above, your mysql server was NOT started in the first place, that is why the command started it for you, if your mysql server had already started, the command will say so and will not start another server process.
Please read http://dev.mysql.com/doc/mysql/en/Windows_installation.html
to familiar yourself with the complete installation steps.
As for the file my.cnf, it is equivalend to your my.ini file.
ASKER
I think I was having a right's issue. I reinstalled MySQL and everything is fine. Thanks for your help.
ASKER
When I type this at the command line:
mysql mysql -h localhost
I receive a list of options/switches.
When I type this at the command line:
mysqld-nt --console
It tells me that its: "Ready for connections."
Why I search my entire harddrive, I can't find a "my.cnf" file. Am I supposed to have one?
Please help!