问题原文
原帖链接 · 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!
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
