How To Assign a User to a MySQL Database in cPanel

Posted on by dpepper
Reading Time: 2 minutes

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to assign a user to a database.

  1. Click the “MySQL Databases” icon.cpanel-pl-mysql-5-assignuser-02
  2. Under “Add User To Database”, select the user you want to add, and then select the database you want to add it to.cpanel-pl-mysql-5-assignuser-03
  3. When ready, click “Add”.cpanel-pl-mysql-5-assignuser-04
  4. Select the privileges you want to grant the user… in this case, let’s select “All Privileges”.cpanel-pl-mysql-5-assignuser-05
  5. Then click “Make Changes”.cpanel-pl-mysql-5-assignuser-06
  6. That’s it! The user has been assigned to the database.cpanel-pl-mysql-5-assignuser-07
  7. You can see the user assigned to the database in the table of databases.cpanel-pl-mysql-5-assignuser-08

 

About the Author: dpepper

Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985
1.517.322.0434

Latest Articles

What is a Webhook?

Read Article

Microsoft Exchange Server Security Update

Read Article

How to Monitor Your Server in WHM

Read Article

How to Monitor Your Server in WHM

Read Article

How to Fix Typical WordPress Errors

Read Article