大网数据广告活动
服务器运维问答

Can't create a new user with all privileges on AWS RDS MySQL instance

· 52CE 我爱测

I've initiated a AWS RDS MySQL instance and would like to create an additional user, who has all privileges on all databases; grant all privileges on *.* to "someuser"@"10.0.0.0/255.255.0.0"; ERROR 1045 (28000): Access denied for…

问题原文

原帖链接 · manifestor · CC BY-SA 4.0

I've initiated a AWS RDS MySQL instance and would like to create an additional user, who has all privileges on all databases;

grant all privileges on *.* to "someuser"@"10.0.0.0/255.255.0.0";
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

As you can see, I'm not allowed to do so, even though I'm triggering the command as root.

How can I solve this?

社区高分解答

原帖链接 · Alexey Vazhnov · CC BY-SA 4.0

It is not allowed in RDS to grant all permissions to *.*, but you can use a trick:

GRANT ALL PRIVILEGES ON `%`.* TO 'someuser'@XXX;

Also, don't forget: ALL [PRIVILEGES] gives all permissions except GRANT OPTION and PROXY!

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2019-04-03)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。