Trying to connect remotely to a MySQL server
Posted on 2016-10-07
I'm running MySQL version 5.6.22 on a Win 2012 server and am trying to create a web interface which will allow me to manage users remotely.
I've got the PHP code working locally but am now trying to connect to this server remotely and running into problems. The Port is open from this server to our LAN address but when I try to connect using telnet I get the following error:
Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server.
So I thought I would dial it back a bit and test locally on the server.
So I'm now testing locally on the server and I can connect using:
mysql -h localhost -u administrator -p
but if I try:
mysql -h xxx.xxx.xxx.xxx -u administrator -p
It prompts to enter the password as usual but then gives me:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
I'm sure I have perms to connect from any host as I ran:
SELECT User,Host FROM mysql.user;
| User | Host |
| administrator | % |
| root | 127.0.0.1 |
| root | ::1 |
| administrator | localhost |
| root | localhost |
I've now come screeching to a halt in my knowledge of MySQL and could really do with some guidance please.