Question
Remotely connecting to MySQL
Tried every tutorial that I’ve found about remotely connecting to the MySQL database. I’ve commented out the bind-address from my.cnf and used GRANT PRIVILEGES ON root@% for all databases.
But I still get the error:
SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘IP ADDRESS’ (61)
when connecting from a different server. While connecting locally with phpMyAdmin works.
Any idea what I can do to get this working?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
Your root account, and this statement applies to any account, may only have been added with localhost access (which is recommended).
You can check this with:
SELECT host FROM mysql.user WHERE User = ‘root’;
If you only see results with localhost and 127.0.0.1, you cannot connect from an external source. If you see other IP addresses, but not the one you’re connecting from - that’s also an indication. If you see %, well then, there’s another problem altogether as that is “any remote source”.
You should be able to add this remote access with:
GRANT ALL PRIVILEGES ON . TO 'root’@’%’;
FLUSH PRIVILEGES;
From: http://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server