MySQL:Can’t connect to MySQL server (10060) from remote client, on windows xp.

I tried connecting to MySQL Server using MySQL query browser but i was getting above error. I found following solution in MySQL forum.

http://forums.mysql.com/read.php?34,49742,239961#msg-239961

I found the problem: i had not added the MySQL Server port in firewall’s exception list.

//<———–part 2

Actually there is no MySQL error with no. 10060. The actual error no. is at the begninning of the error message.(may be ERROR 2003 etc.)

Typically this kind of error message you see due to authentication issues. There could be many reason:
1. The MySQL server isn’t running.
2. Port at which MySQL server is listening is blocked for you.
3. Port at which MySQL server is listening cann’t accept any connection from outside world due to Firewall.

Actually if it is a problem due to Firewall, no need to turn off firewall, you just have to include MySQL listeining port in to unblock/exception list of firewall.

If your MySQL server is running on windows xp, following is the way to deal with firewall problem:
1. Go to Control Panel -> Windows Firewall (Windows Firewall dialog gets open.)
2. Go to Exceptions Tab and click on ‘Add Port…'(Add a Port dialog gets open.)
3. Give the appropriate name.(e.g., MySQL)
4. Give the listening port of MySQL.(Most commonly 3306)
5. Also make sure TCP radio button is selected.

Here is the complete tutorial on how to add a port to Firewall exception list on windows xp.

If sill problem persist refer MySQL documentation, on mysql website for problem regarding MySQL server connection problem.
//———->
modification history:

1. Nov 18, 2009: Due to lot of visit to this post, i added more detail as part 2.

please let me know if this post is useful.

Advertisements

The URI to TrackBack this entry is: https://indiandeve.wordpress.com/2009/08/04/mysqlcant-connect-to-mysql-server-10060-from-remote-client/trackback/

RSS feed for comments on this post.

14 CommentsLeave a comment

  1. You’ll need to ask whoever’s hosting the server as they are denying the connection

    • Thanks Hariharan, i found the solution 🙂

  2. Yes this post works, thanks alot 😀

  3. Thanx, Your reply was helpful. MySQL was not accepting the connection from the remote machine due to firewall. I added the port in firewall, Its working fine now. Thanks again.

  4. Tnx a lot..this post helped me..

  5. thanks a lot! 🙂

  6. thanks a lot, keep up the good work. i am able now to connect from a remote computer

  7. works….. thank uuuuuuuu

  8. Thanks. Helped a lot. Needed to open Port in firewall. Connecting from Windows 7 machine to Windows XP used as server

  9. I’m still not able to connection to the linux mysql from my windows xp even trying to your selection (thanks anyway). The tcpdump from the linux server is reporting windows px client is unreachable

  10. i was able to connect to mysql server running on windows XP from windows 7, but the vice versa is not working, can somebody help me…

  11. Hi Good Afternoon,,,,how is connecting mysql on server mydomainname.give one simple sample example.

  12. Please tell me the steps how to share mysql database in 2 PC from LAN. You can send me mail on given address Thanks in advance.

  13. hi i m conncet mysql to server database how can i do…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: