更新时间:2023-11-30 15:35:16
您***的选择可能是连接到数据库使用mysql命令行客户端,并调用SQL命令来创建一个新用户,并指定他的特权。
Your best bet is probably to connect to the database with a mysql command line client and call the SQL commands to create a new user and assign him privileges.
例如,您可能会遇到这样的事情:
For instance, you might run something like this:
mysql -u [your_master_username] -p -h YOURRDSENDPOINT.rds.amazonaws.com
CREATE USER 'jeffrey'@'%' IDENTIFIED BY 'somepassword';
GRANT SELECT ON [your_database].[some_table] TO 'jeffrey'@'%';
在Windows中,您可以使用mysql.exe客户端,无论是。
On windows you could use the mysql.exe client, wherever that is.
有用的文档
AWS RDS安全组文件(混乱的公共区域):http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithSecurityGroups.html
AWS RDS security groups documentation (a common area of confusion): http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithSecurityGroups.html
用户创建的文档:http://dev.mysql.com/doc/refman/5.5/en/create-user.html
权限授予文件:http://dev.mysql.com/doc/refman/5.5/en/grant.html