Re: ERROR 2003: Can't connect to MySQL server (10060)

[The Woodwose]

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.