How to create MySQL database in the Cpanel

  1. Login to cPanel.
  2. Under Databases, click MySQL Databases.
  3. Type a name for the database in the Database field
  4. Click Create Database.
  5. Click Go Back.

Create database username and password

  1. Click MySQL Users just below your database name
  2. Enter a username and password and click create. (To get a generated strong password, click the Generate Password button)
  3. Click Go Back.

Adding the user to the database

  1. Below MySQL users there is Add User To Database
  2. Select user and the database
  3. Click add
  4. On the next page Manage User Privileges (if you are new just select all Privileges)
  5. Click make changes.

Accessing phpmyadmin

  1. Login to cPanel.
  2. Under Databases, click MySQL Databases.
  3. Click phpmyadmin..

Congratulations on creating the database, user and password, adding privileges and accessing phpmyadmin..

Posted in: Website Hosting