Knowledgebase

how do I add a user to a mysql database?  Print this Article

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

Was this answer helpful?

Also Read

how do I delete a mysql database?
Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...
why do I see: error at line 2: unknown command '\_'. when I list mysql databases?
You have MySQL version 4.0.12 which has a bug that causes this error. Upgrade to a later version...
how do I import a mysql database?
Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....
how do I export a mysql database?
Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....
why does mysql give an access denied error for root@localhost?
To avoid this issue, ensure that the MySQL root password is in the /root/.my.cnf file on the...