Learn how to manage WordPress database with PhpMyAdmin

Most of the Hosting plans provide a dashboard for managing your WordPress website.

Inside your Hosting cPanel, you can find options to manage your WordPress database. You can create WordPress databases, manage users, or change permissions on a WordPress database.

Along with cPanel features, you can also manage your site’s database with PhpMyAdmin, a web-based interface to manage your site’s database.

As compared to cPanel, PhpMyAdmin provides more in-depth features to change database values, take a backup, or supply commands to the server.

In today’s tutorial, we help you learn how to manage your WordPress database with PhpMyAdmin.

You need to have access to your Hosting cPanel area. Among cPanel features, you’ll be using PhpMyAdmin for managing your site database.

What is PhpMyAdmin?

PhpMyAdmin is a web-based database administration tool, written in PHP. As a free tool, PhpMyAdmin helps you handle MySQL databases with a point-and-click interface.

To get started using PhpMyAdmin, you don’t have to go through the installation process. After you’ve finished purchasing your Hosting plan, you can log into your Hosting cPanel, and look for the PhpMyAdmin in the cPanel features.

Why do we use PhpMyAdmin?

While you can easily make necessary changes in the WordPress Dashboard, you may face certain situations, however, where you don’t have access to your WordPress website.

  • You need to use PhpMyAdmin if you don’t have access to the WordPress dashboard.
  • If for some reasons, you’re unable to back up your site in the Dashboard, such as plugin incompatibility.
  • As compared to the Dashboard, PhpMyAdmin provides more in-depth options to manage your site’s database.
  • You need to use PhpMyAdmin if you want to manage the database with a command line. As PhpMyAdmin provides an interface to supply SQL commands, you can manage your site’s database with complex commands. If you would like to go for this option, you need to back up your site first.

If you’re locked out of the Hosting cPanel, you may loss accessing permissions to the PhpMyAdmin. However, it depends on your Hosting cPanel options and policy.

How to manage a WordPress database with PhpMyAdmin?

(1) How to run PhpMyAdmin?

To get started using PhpMyAdmin, you need to log into your Hosting cPanel area and look for the PhpMyAdmin.

hosting cpanel phpmyadmin option

If you couldn’t find PhpMyAdmin in your Hosting cPanel, you can find it somewhere deep in the features. You can also ask your Hosting customer support for assistance.

(2) Find a list of current databases

When you load the PhpMyAdmin, you can see the following screen at the first face.

phpmyadmin interface

To see a list of created databases in your WordPress website, click on the Databases on the top bar.

phpmyadmin shows a list of created databases

From the list, you can click on a Database to show its tables. You can then manage more advanced tables for your WordPress website – the tables that hold data for your site.

(3) How to backup a WordPress database with PhpMyAdmin?

On the top menu bar, the Export option helps you backup your WordPress databases. To get started, click on Export, set the required metrics, and proceed to click on the GO button.

phpmyadmin export option

You can set more advanced options while backing up your site databases with Export option. Click on the Custom to see more features. In the end, the Format list shows different types/formats for the output file. While you can choose various options from the list, make sure you proceed with the SQL.

(4) How to restore a WordPress database with PhpMyAdmin?

In the same manner as Export, you can use the Import option to restore your WordPress database. To get started, click on the Import option, select your file from your computer, and proceed to click on the GO button at the end.

phpmyadmin import option

Make sure you confirm the file type as SQL. When done, you can click on the Go button at the end.

(5) Change user information

PhpMyAdmin provides the options to change user information. By clicking on a database name, the system shows a list of tables in the database.

list database tables in phpmyadmin

At the top, enter the word “Users” in the search field. The system will come up with the table for Users information. To proceed, click on the Users from the search results.

The next page shows users information on your WordPress website. Click on the Edit for the one you would like to change.

change user information in phpmyadmin

After you click the Edit, you can see the fields for changing different information, such as username, email, and password. You can learn more about WordPress User Roles.

Set the required information and proceed to save changes at the end. To kill the PhpMyAdmin window after making necessary changes, you can close the respective browser window or tab.

Wrapping up

As a WordPress beginner, you don’t need to change information with PhpMyAdmin. With that clarified, you may need to use PhpMyAdmin for specific cases, such as having no access to the WordPress dashboard.

You can run PhpMyAdmin from your Hosting cPanel. You may face a different view, however, depends on the Hosting company interface.

Before you make changes with PhpMyAdmin, you should take a backup-copy of your website. It helps you restore your site in bad situations, such as losing administrative control or options.

Proceed to learn more about learning WordPress as a beginner. Also, don’t forget to share your thoughts. Let us know your views by joining the conversation in the comments.

More on wpcrib

1 comment

  1. Thank you so much for this. I was into this issue and tired to tinker around to check if its possible but couldnt get it done. Now that i have seen the way you did it, thanks guys
    with
    regards

Add comment

Join discussion and make an impact. Your email address will not be published.

GDPR is going into effect on May 25, 2018. Learn more in our new GDPR section. You can also view changes to our Privacy Policy.
We use cookies to provide a personalised experience for our users.