//创建用户
CREATE USER auditor@localhost IDENTIFIED BY 'newpasswd';
//分配权限
GRANT ALL ON *.* TO auditor@localhost;
//刷新生效
FLUSH PRIVILEGES
mysql创建用户分配权限
最新推荐文章于 2024-09-20 21:26:51 发布
//创建用户
CREATE USER auditor@localhost IDENTIFIED BY 'newpasswd';
//分配权限
GRANT ALL ON *.* TO auditor@localhost;
//刷新生效
FLUSH PRIVILEGES