如果密码为空首先修改一下密码
UPDATE USER SET PASSWORD=PASSWORD('root') WHERE USER='root';
允许所有IP访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
允许某一个IP访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.XX.XX' IDENTIFIED BY 'root' WITH GRANT OPTION;
记得刷新下
FLUSH PRIVILEGES;