How to assign a user to a MySQL database in cPanel?



To add a MySQL user to a database, follow these steps:

  1. In the Databases section of the cPanel home screen, click MySQL® Databases.
  2. Under Add User to Database, select the user that you want to add in the User list box.
  3. In the Database list box, select the database.
  4. Click Add.
  5. Click the check boxes to grant the user specific privileges, or click the ALL PRIVILEGES check box to grant the user all permissions to the database.
  6. Click Make Changes.

Related Articles

How to remove a user from a MySQL database in cPanel?

To delete a MySQL user, follow these steps: In the Databases section of the cPanel home screen, click MySQL® Databases. Under Current Users, locate the user that you want to delete, and then...

How to manage a MySQL database with phpMyAdmin in cPanel?

You can import and export MySQL databases for a variety of scenarios, including: Transferring a database from one web hosting account or provider to another. Importing a third-party database....

How to repair a MySQL database in cPanel?

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: In...

Does XtraOrbit provide an online tool to manage MySQL databases?

Yes, your web hosting control panel come with an online database managment tool called PhPMyAdmin. phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of...

How to setup a database using the MySQL Database Wizard in cPanel?

To create a MySQL database, follow these steps: In the Databases section of the cPanel home screen, click MySQL® Databases. Under Create New Database, type the name of the database in the New...