MySQL Forums
Forum List  »  MySQL Administrator

Re: ERROR 2003: Can't connect to MySQL server (10060)
Posted by: The Woodwose
Date: November 29, 2008 08:27PM

I know in my case this was a basic issue with security on the database. I'm new to mysql and databases in general and was flopping around with iptables, firewalls, and /etc/mysql/my.cnf stuff and my problem boiled down to just granting access to the user on my remote machine. I'm using mysql server and mysql client on two ubuntu machines and couldn't connect from the client. I could get in on the server just fine. I was using the root id on both machines, but that doesn't mean they are the same id's. They are associated with the host ip. So on the server issue the following sql command.

GRANT ALL ON database.* TO root@'client ip address' IDENTIFIED BY 'password';

As soon as I did that I connected right away from my client machine.

The error message is a little misleading, imo, lol.

Options: ReplyQuote


Subject
Written By
Posted
August 24, 2007 01:26AM
October 16, 2007 07:54AM
October 18, 2007 03:44AM
Re: ERROR 2003: Can't connect to MySQL server (10060)
November 29, 2008 08:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.