How to Manage a MySQL Database With phpMyAdmin in cPanel

Posted on by Ronald Caldwell | Updated:
Reading Time: 3 minutes

While some choose to manage their database from the command line, there are those that prefer a graphical user interface (GUI) to do so. cPanel offers phpMyAdmin, a free and open source tool for MySQL and MariaDB, built into their control panel to manage databases. This guide walks you through how to manage a MySQL database with phpMyAdmin in cPanel.

Requirements

  • A cPanel server.
  • Login credentials for cPanel.

How to Manage a MySQL Database with phpMyAdmin in cPanel

2. Click phpMyAdmin.

3. This is the main phpMyAdmin page. From here you can manage all MySQL or MariaDB databases in your hosting account. In the left-hand column, click the plus sign (+) next to your database.

4. You see a list of tables in your database. Click the one you want to manage.

5. You see a list of actions in that table. You can also click on the database for additional management options such as managing tables, adding or deleting entries, and performing queries among other things.

Wrapping Up

This guide shows you how to manage a MySQL database with phpMyAdmin in cPanel. While this would typically be done by your system administrator, knowing how to access it is helpful for simple tweaks you may need to do. As always, the support team at Liquid Web is available 24/7/365 to assist with MySQL databases.

Liquid Web has cPanel options on our VPS Hosting, Cloud Dedicated Servers, and Dedicated Servers for all your hosting needs. Contact our sales team to get started.

This concludes our MySQL cPanel series. Feel free to check out some of our other tutorials on the Liquid Web Knowledge Base.

Avatar for Ronald Caldwell

About the Author: Ronald Caldwell

Ron is a Technical Writer at Liquid Web working with the Marketing team. He has 9+ years of experience in Technology. He obtained an Associate of Science in Computer Science from Prairie State College in 2015. He is happily married to his high school sweetheart and lives in Michigan with her and their children.

Latest Articles

Blocking IP or whitelisting IP addresses with UFW

Read Article

CentOS Linux 7 end of life migrations

Read Article

Use ChatGPT to diagnose and resolve server issues

Read Article

What is SDDC VMware?

Read Article

Best authentication practices for email senders

Read Article