mysql error 2003

[Anon]

i use php-4.0.3 + mysql-shareware-3.22.34-win.zip + omni httpd 2.07 on a windows 98 SE platform.But when i lauch mysqld-shareware,i received "Error 2003: Can't Connect to MySQL Server on 'localhost' (10050)" .i'm a newbie to mysql,can u help me?thanks lot!

[Anon]

Well,

this is not in any way a very profound answer, but it did the job for me after I had read many profound tips etc., and nothing worked:

I just went to the mysql folder and hit:
mysqlshutdown.exe a couple of times and shut it down, (now I was angry and that helped to release tension anyway)
What can I say - I restart the server and it says hallo and runs, and carries on..

Cheers, P.

P.S. But I also fix the toaster by hiting it a coupla of times...

[Anon]

I had the same error:\\\"Error 2003: Can\\\'t Connect to MySQL Server on \\\'localhost\\\' (10050)\\\"

In my case the reason was the active personell firewall (ZoneAlarm).

So I defined a trusted IP for 127.0.0.1 and allowed the access for Apache to the local zone.

[Anon]

Possible solution:

run 'mysqld' (or any of it's flavors), then connect to the server with the command:
mysql -h 'IPaddress', so e.g
mysql -h 172.21.32.150
This works for me !

Somehow your machine may be confused about the 'localhost', and this command then gets around this.

I had the same problem myself and I still do not understand why it happens. There is a hint to this on page 86 or so of the mysql maual, where it is suggested that the hosts file may not contain the '127.0.0.1 localhost' entry.

In my case there seems to be nothing wrong with the hosts file (win98: hosts and lmhosts file both contain the 127.0.0.1 localhost entry, and I have no firewall runnning on the fialing machine; I do on the other desktop) and it still comes up with '2003' if I do a simple 'mysql' or even a 'mysql -h localhost'.

My own story ? I have a couple of machines in a lcoal network: two desktops and a laptop. exactly the same installation procedure on al three machines resulted in two machines working perfectly fine, and one of them failing with the '2003' error. I first thought it could have something to do with the amount of memory, because the failing machine only had 48 MB, but the solution mentioned above cleared it completely.

I then spent time reading through hundreds of pages vagely or clearly referring to this error, and none of the solutions posted by people in reply worked for me. Then I got down into the manual again and found the reference on page 86. That got me to play with the options on 'mysql' and that finally brought me the solution.

So let us know in this forum whether the psoted solution worked for you. It may help other people to know !

Cheers

John

[Anon]

THANKS!!!!!!!!!!

This worked for me. I set up the mysql server on an NT machine, and when I connect to it remotely from 98 machines, it's sufficient to just start with:

E:\mysql\bin>mysqld
E:\mysql\bin>mysql

And I tried a bunch of different things from the Windows 2000 machine which all gave me the 2003 error, including explicitly specifying -h localhost, trying to set user profiles in the my.ini and my.cnf files, various parameters for the mysqld daemon... none of it worked.

But it did let me on by just specifying the IP address in this way, but now it denies me access to my databases. It thinks my user name is @PC5091 who clearly has no priveleges whatsoever.

:-)