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

Related Articles

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

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

How do I import a MySQL Database?

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