打开Workbench中的sql窗口,输入:
GRANT ALL PRIVILEGES ON *.* TO 用户名@'%' IDENTIFIED BY 'xxxxxx( 原密码)' WITH GRANT OPTION;
FLUSH PRIVILEGES;
如果报错:
%报错:You must reset your password using ALTER USER statement before executing this statement.
%解决办法:将用户名重新改成其他名。