mysql赋予用户所有权限,给mysql用户设置一个的权限

1.创建用户
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
2.刷新权限，使修改生效
FLUSH PRIVILEGES;