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.
  • Open the MySQL Databases page within cPanel.
  • Locate the "Add User To Database" heading.
  • Select the user you want to add the database, and then select the database you want to add the user to.
  • Click "Add".
  • Select the privileges you want the user to have in the database (All privileges is OK for most applications).
  • Click "Make Changes".
    • 28 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 under the "Databases"...

    How do I delete a MySQL user?

    Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

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