How do I add a user to a MySQL database?

  • Login to cPanel.
  • Locate and click on the MySQL Databases icon under the Databases category.
            
  • Locate the Add User To Database heading.
  • Select the user you want to add in the database, and then select the database related to that user.
  • Click Add.
  • Under Current Databases heading click user from Users column to manage privileges.(All privileges is OK for most applications).
  • Then Click Make Changes.

Was this answer helpful?

 Print this Article

Also Read

How do I delete a MySQL user?

Login to cPanel. Locate and click on the MySQL Databases icon in the Databases category....

How do I export a MySQL Database?

Login to cPanel. Locate and click on the phpMyAdmin icon under the Databases category....

What is phpMyAdmin?

phpMyAdmin is a graphical user interface (GUI) used for managing data within a MySQL database....

How do I create a MySQL database?

Login to cPanel. Locate and click on the MySQL Databases icon in the Databases category....

How do I delete a MySQL database?

Login to cPanel. Locate and click on the MySQL Databases icon in the Databases category....