How do I add a user to a MySQL database?

In order to access your database, you need to first create a mysql user and apply that user to your database of choice.

To create a database user:

  1. Log into cPanel.
  2. Under Databases, click MySQL® Databases.
  3. Click Jump to MySQL Users
  4. Under Add New User, enter a username. Be sure that the username is 7 letters or shorter.
  5. Enter a password in the Password field.
    • For help generating a strong password, click the Generate Password button.
  6. Retype the password in the Password (Again) field.
  7. Click Create User.

More info:

Add a MySQL User (cPanel Docs)

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What database settings do I use for scripts?

Server Hostname: localhost Database Username: <your username>_<database name> e.g....

How do I add a wildcard subdomain for Wordpress MU?

This can be easily done by logging into your cPanel control panel and clicking on "Subdomains"....

Do you support Silverstripe Hosting?

Yes, we run Linux servers designed to run the New Zealand developed Silverstripe application. If...

Strict Standards Errors for PHP

If you are getting errors similar to:Strict Standards: Non-static method JLoader::import() should...

Fix permissions of all directories and files

To change all the directories to 755 (-rwxr-xr-x): find /home/xxx/public_html -type d -exec...