Click to See Complete Forum and Search --> : MySQL on Windows 2000
hello,
i installed mysql shareware 3.22.34 for win32 in my windows 2000.
i start mysql whith "mysqld-sharware"
and then i write mysql to connect and i receive this message "error 2003: cant connect to mysql server on localhost" (10011 or something like that)
recently i had mysql on windows 2000(upgrated from millenium) and it was working.
Is there a problem with the login and password or something else?
If your username or password were wrong, it would tell you. One way to check is to go the directory where mysql is installed and type "mysql -u root -p" and if it asks for your password, the server is working. If it doesn't and gives an error like the above one, there should be a program in the bin directory thats called something like "mysqld-nt" or something with "nt" in it, just run that with "mysqld-nt install" and that will install MySQL as a service.
i solved the problem.
when i start tha mysql i write
"mysqld-shareware --default-files=myexample.cnf"
Thanks anyway, anonymoys...
If MySQL is installed into a directory other than "c:\mysql" something that may stop the need for the "--default-files=myexample.cnf" switch is to copy the myexample.cnf file to c:\, rename it to my.cnf, and change the "basedir" directive to wherever you're installed. The reason for this is that by default MySQL expects to find it's files in c:\mysql when it's installed on an NT-based system (doesn't apply to Win98). If it can't find it's files, it obviously can't start:) I don't know if this solution is applicable to your situation, but I thought I'd mention it anyways. Hope this helps!!!
Cheers,
Geoff A. Virgo
PHP Builder
Copyright WebMediaBrands Inc. All Rights Reserved.