授权MySQL root 用户所有权限

-- 登录
mysql -u root -p
-- 查询mysql用户
select user,host,authentication_string from mysql.user;
-- 切换到mysql库
use mysql;
-- 修改root用户host
update user set host='%' where user='root';
-- 授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
-- 刷新
FLUSH PRIVILEGES;