Knowledgebase

How do I add a user to a MySQL database?

  1. Login to cPanel.
  2. Locate and click on the "MySQL Databases" icon under the "Databases" category.
  3. Open the MySQL Databases page within cPanel.
  4. Locate the "Add User To Database" heading.
  5. Select the user you want to add the database, and then select the database you want to add the user to.
  6. Click "Add".
  7. Select the privileges you want the user to have in the database (All privileges is OK for most applications).
  8. Click "Make Changes".

Was this answer helpful?

 Print this Article

Also Read

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 export a MySQL Database?

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

My application is asking for database information - where do I get it?

Nearly all web applications have a database back-end that require a MySQL database. During the...

What is phpMyAdmin?

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

How do I remove a MySQL user from a database?

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