mySQL give permission to a computer IP address

GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.131 IDENTIFIED BY “*************”;

 

 

To get a list of MySQL users:

mysql> select user,host from mysql.user;

Leave a comment