You can perform the following user management operations for Cloud Databases:
These user management functions are readily available from the Users section on the Instance details page.
Users can also be created via the Actions Menu.
Here are some quick facts you'll need to know when creating new users:
The following characters are valid for user names and passwords:
The host parameter should be a string consisting of either a numeric IPv4 address describing the host the user must connect from (such as "192.168.1.12") or the string "%". The string "%" serves as a wildcard to MySQL, and means "from anywhere". Users created without specifying the host parameter are given the default value of "%", which allows them to connect to the database from any host.
The following characters are not allowed when creating user names or passwords:
You have the ability to perform several operations to modify a user by clicking the Action Cog next to their username.
The operations include:
Clicking the Manage Database Access menu item in the Action Cog will let you control user access to each database.
To revoke a user's access to a database, click the "-" button next to the database name in the list.
To grant a user access to a database click the Add Access button. This will display a list of databases for which the user does not already have access. Put check marks next to the appropriate database names and submit the changes to put them into effect.
Note: Currently, users can only be granted or revoked full permissions on a database. You cannot add more specific permissions to a user at this time.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License