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.
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.
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.