phpMyAdmin is a useful tool, written in PHP, to manage the administration of MySQL via a web browser. It provides a graphical user interface for MySQL.
The most frequently used operations are supported by the user interface, though you still have the ability to directly execute any SQL statement.
phpMyAdmin can be accessed via your cPanel control panel.
Accessing phpMyAdmin
Log in to cPanel
Under the ‘Databases’ section click on ‘phpMyAdmin’.
This should now display the main phpMyAdmin interface.
MySQL Processes can be viewed within Status → Processes
Auto-Refresh
If you’re intending to actively monitor the MySQL processes, auto refresh can be enabled to gain a live feed of what is happening to processes on the system. If you’re concerned about the traffic from MySQL to the webserver, manual refreshing is a good alternative.
To kill any processes, simply hit the Kill link beside the desired process.
Killing a process
The Kill option within phpMyAdmin issues a standard SQL kill Command to the process ID in question. To do this within SQL the relevant command is:
KILL [process_id];So for process 285104 the command would be:
KILL 285104;Please note that this will kill the connection
Browsing Databases
To view the structure of your databases, simply click on the database name in the left column of the home page. Alternatively, you can click on the databases tab along the top of the screen.
Click on the ‘+’ next to your databases name to view the tables. Then Click on a Table to see its contents. Navigate through the rows of data by clicking the > or >> buttons; or choose a page number from the drop-down box.
