Managing MySQL databases and users

cPanel provides tools to create, manage, and delete MySQL databases and users. You can also assign privileges, repair databases, and revoke access when needed.

Managing Database Users

1. Creating a Database User

1. Log in to cPanel.

2. Go to Databases → MySQL Databases (or Manage My Databases in newer versions).

3. Under Add New User:

   • Enter a username.
   • Enter and confirm a password (or use the Password Generator).

4. Click Create User.

2. Changing a User’s Password

1. In MySQL Databases, under Current Users, locate the user.
2. Click Change Password.
3. Enter the new password → Change Password.

3. Renaming a User

1. In Current Users, locate the user.
2. Click Rename.
3. Enter the new name → Proceed.

4. Deleting a User

1. In Current Users, locate the user.
2. Click Delete → confirm. Deleting a user also removes all their database permissions.

Managing Databases

1. Creating a Database

1. In MySQL Databases, under Create New Database, enter a name.
2. Click Create Database. Note: cPanel prefixes your account username to the database name (e.g., user_dbname).

2. Adding a User to a Database

1. In MySQL Databases, under Add User to Database:

   • Select the user.
   • Select the database.

2. Click Add.

3. Assign privileges (or select ALL PRIVILEGES) → Make Changes.

3. Checking and Repairing a Database

1. In MySQL Databases, under Modify Databases:

   • Select the database from Check Database → Check Database.
   • If errors are found, select it under Repair Database → Repair Database.

4. Revoking User Privileges

1. In Current Databases, locate the user attached to a database.
2. Click the trash can icon → Revoke User Privileges from Database.

5. Deleting a Database

1. In Current Databases, locate the database.
2. Click Delete → confirm. Note: Deleting a database does not delete its users, but it revokes their privileges.