ERROR 2003 (HY000): Can't connect to MySQL server on xx.xx.xx.xx

Asked Mar 27 '18 at 04:13

Active Mar 27 '18 at 04:13

Viewed 183 times

I tried to connect mySQL from remote server I followed these commands: convert

bind-address = 127.0.0.1

bind-address = 0.0.0.0

and followed by,

systemctl restart mysql.service

then login to mySQL server in local machine and gave following command:

GRANT ALL ON databaseName.* TO 'user'@'xx.xx.xx.xx' IDENTIFIED BY 'password';

then tried in remote server with following command:

mysql -u user -p -h xx.xx.xx.xx

Got error as:

ERROR 2003 (HY000): Can't connect to MySQL server on 'xx.xx.xx.xx'

Can someone help on this? How can I connect mySQL remotely?

asked Mar 27 '18 at 04:13

usergs

1

Possible duplicate of [MySQL unable to connect with remote server](https://stackoverflow.com/questions/21627421/mysql-unable-to-connect-with-remote-server) – Aashish Kumar Mar 27 '18 at 04:20
Did you check firewall? – songoku1610 Mar 27 '18 at 04:28
@songoku1610 No, I did not, – usergs Mar 27 '18 at 04:29
Check your firewall or network first, maybe the firewall blocked your connection – songoku1610 Mar 27 '18 at 04:31
@songoku1610 I checked, it is inactive. – usergs Mar 27 '18 at 04:35

0 Answers0