#创建新用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
#赋予权限:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql创建新用户并赋予与root用户同等的权限
最新推荐文章于 2024-04-08 10:15:40 发布
#创建新用户:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
#赋予权限:
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;