Managing Database Users on the Grid


Browse by products and services

  • Applies to: Grid
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Account Center access

Overview

This article provides instructions on how to change the password for database users on the Grid. You can find more database information within your Server Guide.

Database User Types

On the Grid, we have three distinct user types.

Primary Database User

By default, your Grid comes with one primary database user. This user has read/write permissions to all databases you create on your service. The username will look similar to the following:

  • db00000

Additional Database Users

On the Grid, you are allowed to create up to 200 database users. Any database user you create will be formatted as follows:

  • db00000_username

NOTE:

By default, any new database user will have "No Access" permissions to any database. You will need to enable "Read Only" or "Read/Write" permissions for each user.

1-Click Database Users

Any database user created using the 1-Click Application feature will not count toward your total database user count. A database user created using the 1-Click Application feature will have the 1clk prefix such as:

  • 1clk_wp_zUBRT3T

Managing Database Users

You have four types of actions for database users. You can add new users, change a user's permissions to a database, change a user's password, or delete any Additional/1-Click Database Users.

Adding a new Database User

  1. Select the Admin button adjacent to your Grid hosting service from the Overview page of your Account Center.
    1650_admin
  2. Select Manage Databases from the Databases menu.
    1650_manage_db
  3. Click on Users & Settings.
    1650_users_settings
  4. Scroll down to the Manage Database Users section, and select + Add User.
    1650_add_user_button
  5. Enter a username, and enter a strong password twice.
    1650_create_db_user
  6. Click on Create Database User to create your new user.
    1650_create_user_button

Setting Permissions for a Database User

Your Primary Database User has universal access to all databases on your service. However, on the Grid you can set three types of permissions for an additional databse user.

  • No Access - User is given no access to the database.
  • Read Only - User can view the database, but cannot make changes.
  • Read/Write - User can read and write to database.
  1. Select the Admin button adjacent to your Grid hosting service from the Overview page of your Account Center.
    1650_admin
  2. Select Manage Databases from the Databases menu.
    1650_manage_db
  3. Click on Users & Settings.
    1650_users_settings
  4. Scroll down to the Manage Database Users section, and select Permissions to the right of the user.
    1650_perms
  5. The access levels for each database will appear below the user row. You can choose between No Access, Read Only, and Read/Write for the specific user.
    1650_save_perms
  6. Select the permissions you desire for each database, and click Save to apply these permissions to your database user.

Changing the password for a Database User

On the Grid, you can change the password for any of the database users on your service.

CAUTION:

Changing a user password will happen immediately. You must update your database connections. Any applications or scripts using this password will have to be updated to ensure that your applications remain unaffected.

  1. Select the Admin button adjacent to your Grid hosting service from the Overview page of your Account Center.
    1650_admin
  2. Select Manage Databases from the Databases menu.
    1650_manage_db
  3. Click on Users & Settings.
    1650_users_settings
  4. Scroll down to the Manage Database Users section, and select Change Password to the right of the user.
    1650_change_pw
  5. Enter and confirm your new password, making sure that it adheres to our strong password guidelines.
    1650_update_pw
  6. Select Update Password to update the user's password.

Deleting a Database User

On the Grid, you can delete any user other than the primary database user.

CAUTION:

Deleting a user password will happen immediately. You must update your database connections. Any applications or scripts using this password will have to be updated to ensure that your applications remain unaffected.

  1. Select the Admin button adjacent to your Grid hosting service from the Overview page of your Account Center.
    1650_admin
  2. Select Manage Databases from the Databases menu.
    1650_manage_db
  3. Click on Users & Settings.
    1650_users_settings
  4. Scroll down to the Manage Database Users section, and click on "Delete" for the user you wish to remove.
    1650_delete
  5. When prompted, confirm that you wish to delete the user by clicking the red Delete User button.
    1650_confirm_delete

FAQs

Q: Must all the database users I create start with db00000_ in the prefix?
A: Yes, at this time, all database users manually created must start with db00000.

Q: I changed the password for one of my 1-Click Application database users. Now, my site will not work.
A: If you change the password for any of your 1-Click Application database users, you MUST update the configuration file for that application by providing the new password.

Q: I changed the password for a database user, and now I can't log in to phpMyAdmin, why?
A: Many times your browser may save your phpMyAdmin login information so you don't need to login everytime. If you change your password, then you may need to clear your browser's cache. Once that is done, you should be able to log in with the new password.