MySQL 8.0.11 版本之后
创建用户方法如下:
CREATE USER 'liujing'@'localhost' IDENTIFIED BY '123456';
授予账户权限的方法如下:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO 'liujing'@'localhost';
授予所有权限:
GRANT ALL PRIVILEGES ON *.* TO 'liujing'@'localhost';
查看用户权限:
发表评论