Create a Database with cPanel and phpMyAdmin

Create a Database with cPanel and phpMyAdmin

Creating a database is one of the common tasks before building a new site with WordPress, Joomla or Drupal.

Luckily, phpMyAdmin and cPanel make this process easier than ever.

In this post, I'm going to show you how to create a new database and link to a database user. Let's start...

Step #1. Login to cPanel

Go to your cPanel and login. It’s commonly reachable from www.yoursite.any/cpanel.

New Database with phpMyAdmin

Step #2. Create a new database

  • In the databases section, click in "MySQL® Databases".
New Database with phpMyAdmin
  • In "Create a new database" section, type a unique name and click "Create database".
New Database with phpMyAdmin

If everything is ok, a successful message will come up in the next screen and you will see the full name of your database.

For example: something_mydatabase

  • Click "Go back" button.
New Database with phpMyAdmin

Step #3. Create a new database user

It's common practice to create a unique user for each database.

  • Scroll down to "Add a New User" section.
  • Type a unique username, using as maximum 7 characters.
New Database with phpMyAdmin
  • Click "Password generator".
New Database with phpMyAdmin

Copy the generated password and temporarily save it. For example: paste the password into an open text file, so you can use later while installing WordPress, Drupal or Joomla.

  • Check "I have copied this password to a secure location"
  • Click "Use password" button.
New Database with phpMyAdmin
  • "Create user".
New Database with phpMyAdmin

If everything is OK, a success message will come up in the next screen and you will see the new username.

For example: something_myuser

  • Click "Go back" button.

Step #4. Add a user to the database

Scroll down to "Add a User to a Database" section.

  • Select the User and Database.
  • Click "Add".
New Database with phpMyAdmin
  • In the next screen, click "All privileges".
  • Click "Make changes".
New Database with phpMyAdmin
  • A success message will confirm the user now has all the privileges over the database.
New Database with phpMyAdmin
  • Click the "Go back" button.

About the author

Valentín creates beautiful designs from amongst the tequila plants of Jalisco, Mexico. You can see Valentín's design work all over this site and you can often find him helping members in support.