To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.
To create a MySQL database user, follow these steps:
You can change a database user’s password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.
To change a MySQL user’s password, follow these steps:
To rename a MySQL user, follow these steps:
When you delete a user, the user and its database permissions are deleted.
To delete a MySQL user, follow these steps:
After you create a database user, you are ready to create a database and associate the user with the new database.
To create a MySQL database, follow these steps:
To add a MySQL user to a database, follow these steps:
You can check MySQL databases for errors or possible corruption. If a database check reveals problems, you can repair the database as well.
To check and repair a database, follow these steps:
When you revoke a database user’s privileges, the user can no longer access the database. To do this, follow these steps:
Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.
To delete a MySQL database, follow these steps:
For more information about MySQL, please visit http://www.mysql.com.
Office 154 182-184 High Street North, East Ham
+44 7537 107 846
Switch The Language