Shell,mysql开启远程访问

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

允许局域网内192.168.访问

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

修改/etc/mysql/my.cnf,注释bind-address

#bind-address = 127.0.0.1