Overview

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

Database User Types

On the (gs) Grid-Service, we have three distinct user types:

1. primary database user
2. additional database users
3. 1-Click database users

Primary Database User

By default, your (gs) Grid-Service 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 (gs) Grid-Service, you are allowed to create up to 5 additional users. If you require more users, please consider a MySQL GridContainer. For a detailed list of the database user limits for each container, click here. Any database user you create will be formatted as follows:

• db00000_username

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

The following are instructions on how to add a database user.

1. Log into your AccountCenter.
2. Choose your primary domain from the domains tab.
3. Click on "Manage Databases."
4. Click on the "Global Settings" tab.
5. Now, you should see a section labeled "Add a Database User."
6. Type in a username, and type in a strong password twice.
7. Click on "Save" and now you are done.

Setting Permissions for a Database User

On the (gs) Grid-Service you can set three types of permissions:

• No Access - User is given no access to database.
• Read Only - User can view the database, but cannot make changes.
• Read/Write - User can read and write to database.

1. Log into your AccountCenter.
2. Choose your primary domain from the domains tab.
3. Click on "Manage Databases."
4. Click on the "Global Settings" tab.
5. Now you should see a section labeled "Manage Database Users."
6. Under the "Manage" column for your database user, click on "Permissions."
7. Select the permissions you desire for each database, and click Save.

Changing the password for a Database User

On the (gs) Grid-Service, you can change the password for any of the database users on your service.

1. Log into your AccountCenter.
2. Choose your primary domain from the domains tab.
3. Click on "Manage Databases."
4. Click on the "Global Settings" tab.
5. Now you should see a section labeled "Manage Database Users."
6. Click change for any user whose password you wish to change. Be sure to choose a strong password.
7. Click "Save" and now you are done.

Deleting a Database User

On the (gs) Grid-Service, you can delete any user other than the primary database user.

1. Log into your AccountCenter.
2. Choose your primary domain from the domains tab.
3. Click on "Manage Databases."
4. Click on the "Global Settings" tab.
5. Now you should see a section labeled "Manage Database Users."
6. Click on "Delete" for the user you wish to remove.
7. When prompted, confirm you wish to delete the user.

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 login 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 login with the new password.