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 utilizatori au considerat informaţia utilă
Răspunsul a fost util?

Related Articles

What Do I Put for the Cron Job Command ?

Linux web hosting contains the following: Shared, Reseller, VPS and Dedicated. The instructions...

Managing Your Database with Applications

 There are many applications that can be set up on your pc for managing your databases. Here...

Custom error pages

To make a customized error web page for your consideration, please sign in to cPanel and...

Improve the Security of your WordPress website

Reprise Hosting offers WordPress to all customers through Softaculous, which can be found in the...

Apache Handlers, running html as php

Apache handlers allow you to control what Apache will do with certain pc file types. When Apache...