Managing MySQL databases and users Print

To manage MySQL database users using cPanel, you can follow these steps:

Creating a Database User

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                           
3. Under "Add New User," enter the desired username and password.
4. Click "Create User" to create the database user.

Changing a User's Password

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                                
3. Under "Current Users," locate the user and click "Change Password."
4. Enter the new password and click "Change Password" to update it.

Renaming a User

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                               
3. Under "Current Users," locate the user and click "Rename."
4. Enter the new name and click "Proceed" to rename the user.

Deleting a User

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                                        
3. Under "Current Users," locate the user and click "Delete."
4. Confirm the deletion by clicking "Delete User."

To manage databases:

Creating a Database

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                                                
3. Under "Create New Database," enter the desired database name.
4. Click "Create Database" to create the database.

Adding a User to a Database

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                                           
3. Under "Add User to Database," select the user and the database.
4. Choose the desired privileges and click "Make Changes" to add the user to the database.

Checking and Repairing a Database

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                         
3. To check a database, select it under "Modify Databases" and click "Check Database."
4. To repair a database, select it under "Modify Databases" and click "Repair Database."

Revoking Privileges from a Database User

1. Log in to cPanel.
2. Open the MySQL Databases tool:                                                                                                                                          
3. Under "Current Databases," locate the user and click the trash can icon.
4. Click "Revoke User Privileges from Database" to revoke the user's privileges.

Deleting a Database

1. Log in to cPanel.
2. Open the MySQL Databases tool.
3. Under "Current Databases," locate the database and click "Delete."
4. Confirm the deletion by clicking "Delete Database."

By following these steps, you can effectively manage MySQL database users and databases using cPanel.