如何让其他主机访问自己的mysql数据库

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

 

允许用户root从ip为192.168.1.3的主机连接到mysql服务器，并使用root作为密码

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'root' WITH GRANT OPTION;