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

lincoln
asked May 2, 2018
1 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;
View More
parthiban
answered May 15, 2018
Your Answer
||||
x
 
100:0