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 Kasutajad peavad seda kasulikuks
Kas see vastus oli kasulik?

Related Articles

Local, Backup, and Remote Mail Exchanger

 This is a setting that informs Reprise Hosting how to handle your inbound e-mails. We...

Secure cPanel Login

Using Shared SSL to access cPanel: Simply use https and your IP address, with the secure...

How to change the password of your cPanel account

If you are missing your security password, you can demand a new unique security password through...

How to import your MySQL database

How can I import a database? Firstly, Login to Cpanel Simply, Go to phpMyAdmin Click...

How to copy a database in phpMyAdmin

    Choose the database which you would like to duplicate (by simply clicking the...