How to Create WordPress Database in PhpMyAdmin

How to Create WordPress Database in PHPMyAdminWhen you are installing WordPress on your localhost or a remote server, you are required to create a database since WordPress works with the MySQL database. If you have not created WordPress site before, you can learn how WordPress connects to the MySQL database here – how to connect WordPress to MySQL database.  To create WordPress database you can either use a graphical user interface like PHPMyAdmin or you can create WordPress database using command line.

Create WordPress Database PHPMyAdmin [Summary]

To create WordPress database in PHPMyAdmin is a straightforward process that beginners can easily undertake.

Unlike creating WordPress database on command line, the PHPMyAdmin provides you with a visual presentation.

The following is the summary of the steps you will undertake when creating WordPress database using PHPMyAdmin:

  1. Log in to your web host Plesk to access the control panel. For localhost, you should visit the http://localhost/phpmyadmin URL on your browser when Apache and MySQL are running.
  2. Locate the PHPMyAdmin button on the hosting Control panel if you are creating the database on a remote server or your hosting account.
  3. Click on the PHPMyAdmin icon and you should be redirected to the PHPMyAdmin interface where you can now create a WordPress database.
  4. Click on the ‘Databases’ menu and you will see the fields to create the database; you should add the name of the database and click on the ‘Create’ button.
  5. You have successfully created a database for WordPress but you should also create a user so that you can easily install WordPress using the database and the database user.

Step by Step Create WordPress Database PHPMyAdmin

Now lets us create WordPress database using PHPMyAdmin in a step by step as outlined in the summary above:

#1) Log into PHPMyAdmin for Remote Server/ Hosting

How to Create WordPress Database in PHPMyAdmin

After logging into your web hosting control panel, you should see the PHPMyAdmin button and for the localhost on your browser type http://127.0.0.1/phpmyadmin and you should see the PHPMyAdmin panel as shown in the image below:

How to Create WordPress Database in PHPMyAdmin

#2) Locate the PHPMyAdmin Control panel

If you are on a control panel for any web hosting, you can access the PHPMyAdmin interface using the button provides as shown in the image below:

How to Create WordPress Database in PHPMyAdmin

Depending on your website you may be required to renter the CPanel password to access the PHPMyAdmin while some are just an automatic redirect.

Some web hosting may also restrict the use of PHPMyAdmin to create databases and this may be replaced with MySQL database creation wizard.

You can still create a database on such web hosting through PHPMyAdmin by running a create database query.

#3) Create MySQL Database for WordPress

You can click on the new menu on the top of the left database list; you will see the field to add the name of the database.

How to Create WordPress Database in PHPMyAdmin

For this tutorial, let’s presume you have the field to add the database name as shown in the image below:

How to Create WordPress Database in PHPMyAdmin

Add the name of the database on the field as shown above and click on the create button on the right side. You will successfully create the database that can be seen on the list of the databases on the left as shown in the image below:

How to Create WordPress Database in PHPMyAdmin

Now you can continue to the next step of creating the database user that you will use to install WordPress on your localhost or remote hosting.

#4) Create Database User in PHPMyAdmin for WordPress Database

Now we need to select the database we just created so that we create a user for the database. Click on the database we created to select it from the list of databases. Then click on the privileges menu as shown below:

How to Create WordPress Database in PHPMyAdmin

On this privileges page, you should click on the add user link and add the details for the new database users.

Add New Database User Details 

The new user needs a username, host and password that will be used in the WordPress installation process.

You should add the username that is easy to remember and you can generate the password using the password generator.

For the host, you should select localhost since it’s the location of the database we have created above:

How to Create WordPress Database in PHPMyAdmin

Assign New User Global Privileges

In this step, you should assign the new user Global Privileges so that you can use the user in the WordPress installation process. You should click on the checkbox to select all the global privileges and click on the Go button to create the database user and assign them global privileges.

How to Create WordPress Database in PHPMyAdmin

After clicking the go button, you should see the successful query message output and also a notification that the user has been added to the WordPress database as shown in the image below :

The query message displayed should be like the following:

CREATE USER 'joetheadmin'@'localhost' IDENTIFIED BY 
'***';GRANT ALL PRIVILEGES ON *.* TO 'joetheadmin'@'localhost' 
IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 
0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 
0;GRANT ALL PRIVILEGES ON `njengahtutorial`.* 
TO 'joetheadmin'@'localhost';

This simply shows that you created the user named joetheadmin on the database named njengahtutorialand on the localhost and you granted them all the global privileges.

You can now move to the next step of installing WordPress using the details of the database you created in this tutorial. The details that you require include:

Database name  njengahtutorial
User joetheadmin
Password password you used
Host localhost

How to Connect WordPress to MySQL Database

Wrapping Up

If you followed these steps you should create a WordPress database that you can now use to manually install WordPress on your localhost or remote server. It is important that every WordPress webmaster, website owner or WordPress developer learns how to use PHPMyAdmin for the management of WordPress databases. This can be a good tutorial to get you started learning how to use PHPMyAdmin for WordPress database management.

Similar Articles