How to Manage MySQL Databases in cPanel

Create a Database

1. Go to Databases > Manage My Databases.
2. Enter the database name.

3. Click Create Database.
4. Click Go Back when cPanel confirms the database has been created.

Create a Database User

1. Scroll to MySQL Users.
2. Enter a username.
3. Enter and confirm a strong password.

4. Click Create User.
5. Click Go Back.

Add a User to a Database

1. Scroll to Add User To Database.
2. Choose the user.
3. Choose the database.
4. Click Add.

5. Choose the privileges the user needs.
6. Click Make Changes.

Change a Database User Password

1. Scroll to Current Users.
2. Find the user.
3. Click Change Password.
4. Enter and confirm the new password.
5. Click Change Password.

Rename a Database

1. Scroll to Current Databases.
2. Find the database.
3. Click Rename.
4. Enter the new database name.
5. Confirm the change.

Repair a Database

1. Scroll to Modify Databases.
2. Choose the database from Repair Database.
3. Click Repair Database.

Delete a Database or User

1. Find the database or user you want to remove.
2. Click Delete.
3. Confirm the deletion.

Notes

• Removing a user from a database does not delete the database.
• Deleting a database deletes the data inside it.
• Take a backup before deleting or renaming an important database.