玖叶教程网

在MySQL 5.x版本直接一条SQL 就可以创建用户并授予权限；而8.x后，需要先创建用户，再GRANT权限。

MySQL 5.x:

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

MySQL 8.x:

创建账户:

create user '用户名'@'访问主机' identified by '密码';

赋予权限:

grant 权限列表 on 数据库 to '用户名'@'访问主机' ;(修改权限时在后面加with grant option)

具体示例：

create user 'USERNAME'@'%' identified by 'PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

# 不推荐，字段可能有所改变

use mysql;
update user set host = '%' where user = 'USERNAME';