Window MySQL远程连接不上的解决
原创
©著作权归作者所有:来自51CTO博客作者wx6311aa5a3b012的原创作品,请联系作者获取转载授权,否则将追究法律责任
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;