#创建新用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
#赋予root权限:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
#赋予普通权限:
GRANT ALL PRIVILEGES ON db.* TO 'username'@'localhost'
#刷新权限
FLUSH PRIVILEGES
mysql添加用户权限
最新推荐文章于 2024-10-02 12:42:27 发布