Create or Delete a MySQL Database

Create a MySQL Database

  • Just Log into cPanel.
  • Under Databases,just click MySQL Databases.
  • In the New Database field, type a new unique name for the database.
  • Just Click -> Create Database.
  • Just Click ->Go Back.

The new database will appear in the Current Databases table.


Delete a MySQL Database
  • Move towards the Current Databases section of MySQL Databases.
  • Click Delete Database next to the database which you would like to delete.
Del DB

Create or Delete a Database User


  • Just Log into cPanel.
  • Under Databases,Just click MySQL Databases.
  • Just Click Jump to MySQL Users in the top-right corner of the page.
  • Under Add New User, enter a username.


http://thesysadminblog.com/wp-content/uploads/2013/08/Database_Username.png


  • Just Enter a secure password in the Password text field.
    • For help generating a strong password, click the Generate Password button.
  • Simply, retype the password in the Password (Again) field.
  • Click Create User.

Delete a Database User

http://thesysadminblog.com/wp-content/uploads/2013/08/deleteSQLuser.png

  • Move toward the 'Current Users' under MySQL Databases section.
  • X next to the user you wish to delete.


Assign Privileges to Database User


  1. Simply, Log into cPanel.
  2. Under Databases, click -> MySQL Databases.
  3. Under -> Add User to Database, Just select -> a user from the User drop-down menu.
  4. From the Database drop-down menu, select -> the database to which you would like to allow the user access.
  5. Just Click Add.
  6. Now, select the privileges you wish to grant to the user, or select ALL PRIVILEGES.


http://thesysadminblog.com/wp-content/uploads/2013/08/Database_Privileges.png

  • Click Make Changes.




  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

What is FTP?

The File Transfer Protocol (File Transfer Protocol) or FTP, is a communication protocol...

Connecting to an FTP server

Using the Quick Connect barUsing Site ManagerYou can use the FileZilla Site Manager to specify...

How to log into cPanel

cPanel (control Panel) is a management tool based on web technologies for managing sites easily,...

How to Connect to the MySQL Database

To work with the database in PHP, you must first connect the script to the MYSQL Database. We...

Managing Your Database Using phpMyAdmin

Migrating WordPress website is certainly not something that we have to do every day, but it...