How to Access phpMyAdmin using a Plugin in WordPress

How to Access phpMyAdmin using a Plugin in WordPress?

Do you know that you can now able to Access phpMyAdmin using a Plugin in WordPress without needing to login cPanel? Yes you can now.

Let’s explore the option with step by step guidance in this article.

Access phpMyAdmin using a Plugin

 

What is phpMyAdmin?

phpMyAdmin is simple web based tool used to manage MySQL and MariaDB databases without any command line commands. In cPanel, you can find this option by default which allows you to perform administrative tasks such as creating and modifying databases and tables, running SQL queries, managing user privileges, importing/exporting data, and backing up your database.

 

Before Accessing phpMyAdmin, have the details below:

1. Purchase Hosting Plan

2. Login to cPanel of the website

2. Install WordPress

3. Install SSL

 

Steps to Access phpMyAdmin using a Plugin:

Step 1: Login to WordPress

Step 2: Click Plugin -> Add new plugin

Plugins - Add New Plugin

 

Step 3: Enter “phpMyAdmin” in search box to find the pluginWP phpMyAdmin and click “Install” button.

Install WP phpMyAdmin

 

Step 4: Click “Activate” button to successfully install the plugin.

Step 5: To access phpMyAdmin of the website with currently configured database only, click “Enter Local phpMyAdmin”  button. If you need, you can also access phpMyAdmin directly without cPanel

Enter Local phpMyAdmin

NOTE: If you are using any security plugin, it might places specific restriction in htaccess. So,you might need to turn off “Disable PHP in Plugins” setting : Security > Settings > System Tweaks > PHP in Plugins , othewise you might be restricted to enter PMA)

 

It will take you directly to the phpMyAdmin interface in cPanel. You can only able to see the database which is configured to the website wp-config file but not any other database created.

Enter Local phpMyAdmin Access

 

Step 6: To view all databases for your website, enter the phpMyAdmin login URL and click “Enter Hosting’s phpMyAdmin.”

Enter Hosting's phpMyAdmin

 

You can find this URL by logging into cPanel, selecting phpMyAdmin, and copying the URL from the address bar.

phpmyadmin login url

 

It will take you directly to the phpMyAdmin interface in cPanel and can able to see the all database created for the website.

Enter Hosting's phpMyAdmin Access

 

Step 7: You can restrict or disallow anyone to access phpMyAdmin directly from WordPress dashboard by clicking the checkbox near “Restrict access only to current IP”.

Restrict access IP - phpMyAdmin

Additional Resources:

  1. Add WordPress admin user in phpMyAdmin
  2. Export and upload a database in phpMyAdmin on cPanel
  3. Connect MySQL database in WordPress
  4. Find WordPress database name
  5. Download Full Website Backup in cPanel

 

 

 

Hope the information is helpful and allow you access phpMyAdmin in different ways.