服务器数据库mysql远端不能访问

服务器数据库mysql远端不能访问

需要进root的mysql

mysql -uroot -pzjpfrxly

use mysql

SELECT User, Password, Host FROM user;

需要加一个%的host

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

SELECT User, Password, Host FROM user;

FLUSH PRIVILEGES;

FLUSH PRIVILEGES;