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'; 查看用户权限: show grants for 'liujing'@'localhost';