Error messages in older versions of MySQL

MySQL expert Scott Noyes recommends using MySQL 5.0, in order not to miss out on fixes and features that have been added on.

I was installing MySQL 3.23 on Windows XP Home edition. After installation, I tried to run "mysql show" command but I kept geting this error message: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Can you tell me what the problem might be and how I can fix it?

MySQL 3.23 is a very old version; the current recommended release is 5.0. Version 3.23 will still work, but you...

will miss out on a number of features and bug fixes added in the last few years.

The MySQL manual provides a good explanation of the possible issues:

"The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, the network port you specified is the one configured on the server, and that the TCP/IP port you are using has not been blocked by a firewall or port blocking service."

This was last published in August 2006

Dig Deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: