mysql5.7创建用户并授权，MySQL8如何创建账号并授予权限

mysql5.7创建用户并授权，MySQL8如何创建账号并授予权限create user 'USERNAME'@'%' identified by 'PASSWORD'; GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%'; GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;# 不推荐，字段可能有所改变具体示例：create user '用户名'@'访问主机' identified by '密码';赋予权限:grant 权限列表 on 数据库 to '用户名'@'访问主机' ;(修改权

在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';