GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
//从任何主机连接到mysql服务器。root用户名，123456作为密码.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.28' IDENTIFIED BY '123456' WITH GRANT OPTION;
//允许用户root从ip为192.168.0.28的主机连接到mysql服务器，并使用123456作为密码。
flush privileges;
//修改立即生效
linux:改了还是无法连接10061
根据my.cnf找bind-address=127.0.0.1注释掉
再GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.252' IDENTIFIED BY '123456' WITH GRANT OPTION;（执行这个不用选择库）
flush privileges;
然后sudo service mysql restart
linux连接数据库13错误
SQLSTATE[HY000] [2003] Can't connect to MySQL server on '192.168.1.254' (13)
getsebool -a|grep httpd
发现httpd_can_network_connect-->off
setsebool httpd_can_network_connect 1