How to Create and Delete a MySQL User in cPanel?

This tutorial will explain how to create a MySQL database user in cPanel. Once created, you’ll want to assign it to a database.

Quick Steps:

  1. Log into cPanel & locate the MySQL Databases icon
  2. Scroll down and locate the MySQL Users heading
  3. Enter a username in the field provided
  4. Enter a password twice into the provided fields (or use the generator)
  5. Click “Create User
  6. To delete a user, go to the section “Current Users” and the click “Delete

Scroll down to the “Add User To Database” section to assign a user and grant permissions to a MySQL database. Then choose the specific user from the drop-down list and the corresponding database you wish to allow the user access to. When ready click “Add“.
Select the privileges you want the user to have or select “All Privileges” to give them all and then click “Make Changes“.

  • create mysql user, delete mysql user
  • 0 Users Found This Useful
這篇文章有幫助嗎?

相關文章

How to show hidden files (.htaccess) in cPanel File Manager?

Many users ask us how they can see the .htaccess files for their websites in cPanel File Manager....

How Can I Compress / Uncompress Files Using the File Manager?

How to Compress Files Go to the File Manager. Navigate to the folder where the files you want...

How to View Your cPanel Disk Space Usage?

In order to view your cPanel disk space usage, there’s a great tool located inside of your...

Accessing webmail for your domain

To access the included webmail email clients included with your hosting account, you’ll need to...

How to rename a database in phpMyAdmin?

phpMyAdmin is a free and opensource application for MySQL database management. It is one of the...