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! 
  • 59 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

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

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...