MySQL8.0+用户管理及数据库权限分配

新建用户

CREATE USER username IDENTIFIED BY 'password'

修改用户密码

ALTER USER username IDENTIFIED BY 'newPassword'

删除用户

DROP USER 'username'@'%'

查看用户权限

SHOW GRANTS FOR 'username'@'%'

分配数据库权限

GRANT ALL ON databaseName.* TO 'username'@'%'