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.

Author

  • Valentin Garcia

    Valentin discovered Joomla in 2010, and since then he has considered it as the best CMS. Valentin has been coding extensions and templates for Joomla for many years and truly enjoys helping people build their own websites with Open Source tools. He lives in San Julián, Jalisco, México.

    View all posts
0 0 votes
Article Rating
Subscribe
Notify of
guest

4 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Prashant
Prashant
7 years ago

Sir,

Tell me. Where to find the username and password for cpanel

Daniel Pickering
7 years ago
Reply to  Prashant

By default the details should match the master account for your contract. For many linux configurations this is “root” and then a password you may need to contact your host to find out your default host password.
Thanks

Daniel

dhineshbabu
dhineshbabu
6 years ago

thanks for the basic level information for account opening with image.

Alex Smirnov
6 years ago
Reply to  dhineshbabu

You are most welcome.

4
0
Would love your thoughts, please comment.x
()
x