In this guide, we will introduce you to phpMyAdmin, a web based mySQL client you can use to manage your databases. There are many tools and features that phpMyAdmin includes, but in this article we’re only going to cover a few basics as it relates to php hosting.
How to log into phpMyAdmin
- Log into your cPanel
- Click the phpMyAdmin icon under the “Databases” heading.
What am I looking at when I log into phpMyAdmin?
When you first log into phpMyAdmin, you’ll see quite a bit of data. For most basic tasks, you’ll select a database in the left menu (see screenshot below) and then begin to manage that individual database.
Selecting a Database
If you click on a database in the left column, it will then load more information specific to that database:
In the top menu, you’ll see various options for the database you’re working with, such as:
Giving Developers phpMyAdmin Access
Please note that sometimes you will want to give a web developer phpMyAdmin access. Instead of giving them your cPanel access data (which is not secure), you can install a separate installation of phpMyAdmin for them so they can access it without having access to cPanel itself. For more help with this, please see:
Installing PHPMyAdmin on your Account