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

Related Articles

What is MySQL?

MySQL is a Relational Database Management System. A relational database adds speed and...

What is the MySQL host name?

The Mysql hostname value is localhost. This is the value you should use when configuring scripts...

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 remove a MySQL user from a database?

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