Follow

Managing Database Users

  • Applies to: Shared Hosting
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Account Center access
  • Applies to: Grid
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Account Center access
  • Applies to: VPS Hosting
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Account Center access
  • Applies to: Legacy DV & VPS Hosting
    • Difficulty: Easy
    • Time Needed: 10
    • Tools Required: Plesk or cPanel access

 

Overview

This article provides instructions on how to manage your database users on a Shared Hosting server.

  1. Log into your Media Temple account.
  2. Click on the ADMIN button associated to your Shared Hosting server.
    blue-admin-cp.png
  3. In the Dashboard, click cPanel Admin.
    cpanel-admin.png
  4. In cPanel, click MySQL Database.
    cp-1.png
  5. The Add New User section will allow you to create new database users.
    cp-1.png
  6. The Add User to Database section will
    cp-2.png
  7. The Current Users section will allow you to update the password, rename, or delete users.
    cp-5.png

Resources

Overview

This article provides instructions on how to manage your database users on a VPS server.

Plesk

1. Login to your domain's Plesk control panel.
2. Click on the Databases icon.plesk1.png

3. Click on User Management.
plesk2.png

4. You will not be in your Database Users menu.
plesk3.png

  • Click on Add Database User to create a new user.
  • Click on Remove to remove a database user.
  • Click on your desired database user to edit an existing user.

5. If you click on an existing user or click on Add Database User, you will be prompted with a menu to edit the user.
plesk4.png

  • Database server: Should be generated for you.
  • Database user name: Input your desired username
  • Password: Input a strong password.
  • Database: Select a desired database or select Any to give the user access to all the databases.
  • Access control: Select the desired permissions for the database user.

cPanel

1. Log into your domain's cPanel account.
2. Click on MySQL Databases.
(Note: Depending on your cPanel theme the location and look of this icon may vary).

cpanel1.png

3. Scrolling down you should see an option to Add New User.

cpanel2.png

3. Or you can also edit Current Users.

cpanel3.png

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.

Was this article helpful?
1 out of 1 found this helpful

Comments