且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

创建一个新的MySQL用户在亚马逊RDS环境

更新时间: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