0

cannot connect to remote MySQL

Hi, when i was trying to connect to my MySQL Server from a remote machine i got following error

Host ' 192.168.1.12'  is not allowed to connect to this MySQL server
CentOS Database MySQL Add a comment
lincoln
asked May 03 2018

Answer

0

You need to grant the privileges for the user account you need to connect with your mysql database, login to your Mysql shell and run the below command

GRANT ALL ON *.* to user_name@'192.168.1.12' IDENTIFIED BY 'password';
flush privileges;
Add a comment
parthiban
asked May 15 2018
edited Oct 05 2018
Post your Answer