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 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

Related Articles

How do I deny IP address access?

Do you want to block someone from viewing your website? This tool will prevent anyone to view...

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

What is a Document Root folder?

The document root is the directory where you store your website files for a domain name. Since...

Improve the Security of your WordPress website

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

Internal Server Error help, 500 error

Internal server errors can be due to a few different factors. Please examine the Error Records in...