How To Assign a User to a MySQL Database in cPanel

Posted on by dpepper | Updated:
Category: Tutorials | Tags: , , , , ,
Reading Time: < 1 minute
cPanel Tutorial: MySQL
I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database in cPanel VI. How To Change a MySQL Database User’s Password in cPanel VII. How To Remove a User from a MySQL Database in cPanel VIII. How To Delete a MySQL Database User in cPanel IX. How To Check a MySQL Database for Errors in cPanel X. How To Repair a MySQL Database in cPanel XI. How To Manage a MySQL Database with phpMyAdmin in cPanel
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
 

Related Articles:

Refer a friend and get hosting credit!