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

Location of Script Configuration Files

4Images Gallery /config.php B2...

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...

Does Google work with addon domains?

A typical issue when developing addon websites is, what about the corresponding subdomain and the...

What are Error Codes?

These designated error requirements are how the server informs visitors about an error...

I Forgot My Password and Need a Reset

Below you will learn more on how to modify security passwords for various records relevant to...