How to assign a user to a MySQL database in cPanel

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

  • First you need to log in to the cPanel while using your web hosting username and password.
  • Then you need to find out and click on the MySQL database wizard.
  • It will take you to the next step where you have to look for the Add User to Database section.
  • Under this section you will find the user you want to add.
  • You also need to select the database that you want to add to the user.
  • Once you are ready click on Add.
  • Select the privileges you wish to add for the user. You can also select All Privileges.
  • Then click on Make Changes. That’s it! 
  • 44 Users Found This Useful
Was this answer helpful?

Related Articles

Optimization and repair of MySQL database

If you have suspicions that the MySQL database is running slowly or appear errors, you need to...

How to Manage a MySQL Database with phpMyAdmin in cPanel

How to Manage a MySQL Database with phpMyAdmin in cPanel? In order to manage a MySQL database...

Optimize MySQL database for more speed

If the MySQL database access times seems high and you feel a slow down you need to optimize your...

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

Which host and port to use to connect to MySQL

MySQL host (hostname): localhostMySQL port: 3306