如何编辑AWS RDS的用户权限 [英] How to edit user permissions for AWS RDS

问题描述

我以前的帖子在这里（ mysqli_query（ ）返回已知表的表不存在-权限问题？），详细说明了我如何解决此问题。

My previous post here (mysqli_query() returns "Table doesn't exist" for known table - Permissions issue?) explains the details of how I arrived at this issue.

我现在确信，我在创建数据库实例时设置的用户名和密码未获得适当的权限，以允许我编辑自己的内容数据库。

I am now convinced that the username and password which I set while creating my DB instance have not been given the appropriate permissions to allow me to edit the contents of the my own database.

这非常令人沮丧，因此，如果有人对如何修改这些权限有任何提示或技巧，我将不胜感激。

This is extremely frustrating, so if anyone has any tips or tricks on how to modify these permissions I would really appreciate it.

为了澄清，当前所有权限都是通过EC2安全组设置的，结果，我什至什至都看不到我在创建数据库时创建的用户名和密码，因此，我似乎无法对权限进行任何其他设置或编辑策略。

To clarify, currently all permissions are set via the EC2 Security Groups, and as a result I cannot actually even see the username and password I created when I made the database, so it doesn't appear that I can set the permissions any differently, or edit the policies.

非常感谢。

亚历克斯

推荐答案

所以我回到了您之前的问题看看你在做什么。名为mysql的数据库是系统数据库。创建表不是一个很好的地方。实际上，此数据库的权限可能受到限制，因为它可能破坏mysql和/或RDS自动化。

So I went back to your previous question to see what you were doing. The database named mysql is a system database. Not a very good place to create tables. In fact the permissions for this database are likely restricted as it can break mysql and/or the RDS automation.

您需要为表创建一个新数据库。尽管在RDS中没​​有超级用户访问权限，但您确实具有对设置的任何数据库的完全访问权限。系统数据库将受到限制。

You need to create a new database for your tables. While you do not get super user access within RDS, you do get full access to any databases that you set up. System databases are going to be restricted.

安全组管理与RDS的连接。与外部防火墙相同。

Security groups manage connectivity to RDS. Its the same thing as an external firewall.

赠款在MySQL内部管理权限。 MySQL手册将说明如何使用它们。

Grants manage permissions within MySQL. The MySQL manual will explain how you can use these.

这篇关于如何编辑AWS RDS的用户权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！