Adding a MySQL User
Posted by David, Last modified by Ashley L on 19 November 2019 04:30 PM

You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the specific database first. Refer to "Grant a user's permissions to a MySQL database" for more information.

Here are the steps:

  1. To access the MySQL Account Maintenance Menu, click on the words "MySQL Databases" on the main screen of your cPanel interface
  2. Enter the name of the new user in the blank field next to "Username:"
  3. Enter the password for the new user in the blank field next to "Password:"
  4. Click on "Add User" to create the new user

Troubleshooting: Creating a user does not automatically allow the user to use a database - you need to grant that user permission to the specific database first. Refer to "Grant a user's permissions to a MySQL database" for more information.

 

(270 vote(s))
Helpful
Not helpful

Comments (0)