Window MySQL远程连接不上的解决

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

GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.200.25' IDENTIFIED BY 'pwd' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

  

posted @ 2020-07-24 10:02  A汉克先生  阅读(1815)  评论(0编辑  收藏  举报