mysql远程登陆

在服务端指定客户端的ip，登陆用户，密码 grant select,insert,update,delete on *.* to root@"192.168.0.9" Identified by "123";

 登陆用：mysql -u root -h 192.168.0.133 -p

 

vi /etc/mysql/my.cnf注释掉#bind-address = 127.0.0.1