无法远程连接mysql服务解决方法

1 win+R 进入cmd命令窗口输入 mysql -u root -p
2 输入mysql登录密码
3 输入以下命令

USE mysql;
SELECT 'host' FROM USER WHERE USER='root';
UPDATE USER SET HOST = '%' WHERE USER ='root';
FLUSH PRIVILEGES;

4

GRANT ALL PRIVILEGES ON *.* TO 'user'@'这里为远程IP地址' IDENTIFIED BY 'mysql密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;

5将上面文字出替换即可