• Go To Website
  • Go To Website
home/Knowledge Base/Databases/Using phpMyAdmin
Popular Search:Reseller Hosting, VPS Hosting

Using phpMyAdmin

Updated on April 10, 2022

PHPMyAdmin is a database management utility for MySQL. This tool allows you to manipulate and manage data in your hosting’s databases—for example, Magento uses a MySQL database to store user data, pages, and posts. In a MySQL database, you can use phpMyAdmin to delete or add records.

What are the most important features of phpMyAdmin?

  • Getting into databases – You may access your databases using phpMyAdmin in cPanel.
  • Creating databases and users — You may create databases and users with phpMyAdmin.
  • Selecting databases — To see the database structure, go to the left column of the home page and click on the database name. By clicking on the database’s name, the structure of the database will be revealed. The structure will list the individual names of the tables that make up your database.
  • Browsing databases — Once a database has been selected, you can browse each table by clicking the Browse link next to the table name while in the Structure view. The Browse view shows the database’s data rows. There is also a link to Create PHP Code based on the current view. You can go across the rows of data by clicking > or >>.
  • Viewing MySQL processes – You can see the current MySQL processes by selecting the tab SQL and running the command showprocesslist. If you want to kill a process, click the kill link to the left of the process ID number.
  • Executing SQL queries — The Query and Structure tabs allow you to execute several queries using semicolons to divide them.

This tutorial will walk you through the processes for using and accessing phpMyAdmin.

To access PHPMyAdmin, you must first log into your cPanel account. Once you’ve logged into your account, look for the PHPMyAdmin icon, or use the search bar in the top right-hand corner.

Using phpMyAdmin

After you’ve clicked on the PHPMyAdmin icon, a new tab will appear in front of you, which will be the phpMyAdmin interface. On the left-hand side of the page, under the cPanel account, you’ll see a list of your databases. If you don’t have any databases, nothing will be listed here.

Interface of Using phpMyAdmin

At the top of the bar, you can see the database you’re now in, as well as the activities you can do within it (such as Import database, Export database, Search, SQL query, and so on). You can also look at the tables that are listed. When you click on this tabling to expand it, you’ll view the contents.

It’s crucial to remember that working directly in the database isn’t recommended unless you don’t have any other options.

 

Was this helpful?

Yes  No
Related Articles
  • How to Install WordPress Online Using Softaculous App Installer
  • Enable or Disable PHP’s GD Extension in cPanel
  • Creating MySQL Users and Databases
  • Listed Hosting Nameservers
  • What is an index page?
  • Website staging with Softaculous
Leave A Comment Cancel reply

Databases
  • Using phpMyAdmin
  • Creating MySQL Users and Databases
  • Cron Jobs: An Overview
  • How to Improve the Performance of Your Hosting
  • A High-Level Overview of HTTP 2
  • Two Simple Methods for Exporting and Importing MySQL Databases
View All 6  
Popular Articles
  • How to Install WordPress Online Using Softaculous App Installer
  • How do I set up my domain’s personal Nameservers?
  • How do I use a browser to dynamically update the host’s IP?
  • How to Preview Your Website on Our Servers
  • Process Of Migration
Categories
  • Domain
    • Transfer
  • SSD Hosting
  • Cloud VPS
  • Migration
  • Resellers
  • Security
    • SSL
  • Databases
  • Affliates
  • WordPress
  • Billings & Payments
  • Email
  • Files & Access
  • PHP
  • Nameservers
  • cPanel
    • Softaculous
  • Backup
  • General

  Using the manager in cPanel

Using cPanel to Access a MySQL Database Remotely  

  • © 2022. Listed Hosting. All Rights Reserved.

Popular Search:Reseller Hosting, VPS Hosting