25th Anniversary Savings | 25% Off Dedicated Servers*Shop Now
25th Anniversary Savings | 25% Off VPS Hosting* †††Shop Now
Dedicated Hosting Deals | From $99/moShop Now
Earn hosting credits and a chance to win an Amazon gift card when you refer friends to Liquid Web!Read our promo rules

How to Manage a MySQL Database With phpMyAdmin in cPanel

Posted on by Ronald Caldwell
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.

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

How to Edit the PHP Memory for Your WordPress Site via WP Toolkit

Read Article

What is CGI-Bin and What Does it Do?

Read Article

Top 10 Password Security Standards

Read Article

Top 10 Password Security Standards

Read Article

How to Use the WP Toolkit to Secure and Update WordPress

Read Article