Creating a Database Using cPanel Print

  • 0

Both of the following tutorials require you to be logged into your cPanel. Click here for instructions on how to log into your cPanel with

Creating a MySQL Database

  1. Log into your cPanel. 
  2. Select MSQL Databases. It looks like this:

  3. You will now create your database. Your database will be prefixed by your username and an underscore:

    Then press Create Database. You should see a confirmation message.

    At this point your database is created, but you will need a user with which to access the database you just created.

Creating a MySQL User

  1. Log into your cPanel. 
  2. Select MSQL Databases. It looks like this:

  3. Now, you will create your MySQL user. Scroll down to MySQL Users:

    This form needs the following information:

    • Username - The username will be prefixed by the hosting account's username
    • Password - The password (and confirmation) can be chosen by the user or generated using the button provided below. As you type your password, the strength meter will judge the difficulty a hacker would have in order to crack it using a score from 0 to 100. You will need to confirm your password by re-typing it if you choose your own password.
  4. Once your create your user. You will need to add it to the database of your choice using the form just below the one you just filled out:

    Select the user and the database, then select Add to continue.

  5. Now you will select which priviledges the user is granted to the database:

    Be sure to be conservative about whichever rights the user has if they're going to be used in production. Select Make Changes when you're ready, and you should be good to go.

From this point on, whenever needed, you can use name of the database you created earlier, and the username and password of the user you just created in order to authenticate.

Was this answer helpful?

« Back

Powered by WHMCompleteSolution