• Sales: 1-800-961-2888
  • Support: 1-800-961-4454

Feedback

Let us know what you think of our Knowledge Center!

Open Cloud Community

Learn about Rackspace products, ask questions, and share your knowledge in our Open Cloud Community.

Managing Users

  • Article ID: 1524
  • Last updated on July 31, 2012
  • Authored by: Rackspace Support
  • (14 Comments)

You can perform the following user management operations for Cloud Databases:

  • Create users
  • Delete users
  • View the databases a user is assigned to

These user management functions are readily available from the Actions cog, Action Menu, and Users section on the Instance details page.

Create%20User%20from%20Instance%20Action%20Cog.png ShowAllDBs.png

Creating Users

Here are some quick facts you'll need to know when creating new users:

  • All users have full privileges on the databases they're assigned to.
  • User names cannot contain more than 16 characters.
  • There is no restriction on the number of characters in a user's password.
  • Users cannot be modified using the Cloud Control Panel. If you need to modify a user, first delete and then recreate the user with the information.

Valid Characters for User Names and Passwords

The following characters are valid for user names and passwords:

  • Letters (upper and lower cases allowed)
  • Numbers '@', '?', '#', and spaces are allowed, but not at the beginning and end of the database name, user name, and password
  • "_" is allowed anywhere in the database name, user name, and password

Limitations on User Names and Passwords

The following characters are not allowed when creating user names or passwords:

  • Single quotes
  • Double quotes
  • Back quotes
  • Semicolons
  • Commas
  • Backslashes
  • Forward slashes
  • Spaces at the front or end of the user name or password

Related Information

Learn More About Cloud Databases



© 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


See license specifics and DISCLAIMER

14 Comments

This is crazy...
"All users have full privileges on the databases they're assigned to"
How to create r/o users?
By Anonymous on Aug. 5, 2012

At the moment, there isn't a facility for creating users with limited access. As I understand it this is a planned feature, it's just not there yet.
By jered.heeschen on Aug. 5, 2012

I agree with you! It seems Rackspace rolled out this service too early...
By German Larrain on Aug. 13, 2012

Hi Support, how to add a database and then use an existing user? Dropping the user and recreating is not very good for me. Is this considered a modification to the user?

Thanks, Jerry
By Jerry Sumpton on Aug. 22, 2012

I'm afraid you can't move a user between databases at this time. They are working on improvements to the user management portion of Cloud Databases.
By jered.heeschen on Aug. 23, 2012

Is it possible to enable mysql instance root user somehow? And this way alter users and databases from some third party applications?

Thanks,

Tommi
By Tommi Luostarinen on Sep. 19, 2012

You really need to work urgently on your CloudDB interfacer. You can't create a new database and assign an existing user to it. You can't create read only user. You can basically do nothing.
By Kasper Sergej on Sep. 25, 2012

This service is off to a good start, but still a little wonky. I really need to be able to manage my users from software or phpmyadmin, as I need to be able to give some users abilities to create databases and other users, and I don't want to give them full access to the rackspace admin console. It would be nice to have a root user with all permissions. When are the new features mentioned coming?
By Talik on Oct. 13, 2012

We have had a few requests for more control over user management. I know more development in that area is planned but I can't give you an estimated date at this time. We'll see what we can find out.

You might also add your comment to our feedback forum, or a vote to an existing feature request:

http://feedback.rackspace.com/forums/71021-product-feedback/suggestions/2784599-database-user-management
By jered.heeschen on Oct. 13, 2012

How can I specify the root user for a DB instance?
By Mark on Mar. 12, 2013

As I understand it, the first user created when you make the database will have root privileges. The permissions aren't more fine-grained than that right now - you can control which users access which databases, but can't specify what actions they can or cannot take.
By jered.heeschen on Mar. 12, 2013

I don't think that's the case. I created only one user--although I didn't name it root--and that user could not create databases or anything. Maybe it needs to be named root. This type of thing needs to be explicit in the console though.
By Mark on Mar. 12, 2013

I guess I should check first off - are you using our Cloud Databases product? If so, then you won't be able to create databases directly with a user in the mysql shell. It will have to be done through the control panel or the API.

If you're using a regular MySQL installation you'll have more control over it, and there should be a "root" user created by default.

Sorry about the confusion. The user in Cloud Databases is more restricted than a regular MySQL root user.
By jered.heeschen on Mar. 12, 2013

Yeah, I'm using the CloudDB product. Ok, thanks for the answer.
By Mark on Mar. 12, 2013

Add new comment