How To Create A MySQL Database Using CPanel

Creating a database in MySQL is a very easy task but with the newbie in mind I’ll show it here step by step.

Step by Step Tutorial

    1. Find the MySQL Databases icon on your CPANEL dashboard.
      create mysql database
    2. Click the MySQL Database icon and you should be redirected to the database page. Find this:
      creating new database
    3. Enter your desired database name. For this tutorial I used weht725
      create mysql database

 

  1. Click “Create Database” button and you should be redirected to a page like this:
    new database name created
  2. We have successfully created a database. Copy the created database name to a notepad. In this case, the database name is warrior5_weht725. You will be using this later.
  3. Click “Go Back” button and then scroll down and find the MySQL Users portion.
    password generated
  4. Enter your desired username. In this tutorial I used wthy982. Click “Password Generator” button to automatically generate your database password.
    password generator
  5. Click “Use Password” button.
    password generated
  6. Click “Create User” button.
    database username created
  7. Database username now created. Don’t forget to copy your new database username and generated database password to your notepad. You will be using this later.

    In this example the database username is warrior5_wthy982 and the database password is aa-1P(xi*l7v.

    Note: Your database password should be different from your cpanel password. I noticed some folks using the same password on the cpanel login and database!

    Now, it’s time to connect your new MySQL database and new Database user.

  8. Click the “Go Back” button. Scroll down until you find the “Add User To Database” portion. If you have a lot of existing databases, simply match the new database you just created with the new username.
    add user to database
  9. Click “Add” button. (See Image above)
    check add priveleges to select all
  10. Tick the box beside the “ALL PRIVILEGES” to select all boxes then click the “Make Changes” button.
    successfully added database
  11. That’s it! You now a have a new functioning MySQL database.