Back to Working with a Database

How To Use PHPMyAdmin

What is phpMyAdmin?

PhpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL databases on the web. It can be used to perform various operations such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

How do I access phpMyAdmin?

**Please change all references of to your domain.**

You will first need to log in to your cPanel, usually found at Once you have logged in you will need to go to the Databases section and click on the phpMyAdmin link:

php myadmin

The phpMyAdmin screen should appear as follows:

admin screen

How do I use phpMyAdmin?

You may select any of your databases in the drop down box on the left hand side. In this example, we selected the database ‘Test’

:test database

Once you have selected a database you can use the tabs at the top of the screen for additional functionality:


Structure: By clicking on this tab you will see a display of the structure and tables of the database that you have selected. You will also have the option of creating additional tables (located at the bottom of the screen), and viewing, editing, and deleting current tables and fields.

SQL: Allows you to run SQL queries on the selected database.

Search: Allows you to search for words or values in the database you have selected. You can specify certain tables and fields to search in or select the entire database.

Query: Query also allows you to run SQL queries on the selected database.

Export: You can easily back up your database by using the export tab. You will need to just select the tables and options you would like and then click Go. You can choose to either export to a file or simply display the data in phpMyAdmin, which you can then copy and paste to another place.

Import: In this tab you may import local files into your database.

Operations: Within this tab you may create a new table, rename the database, and make a copy of the database.

If you encounter any errors or problems with this process, please contact our technical support department. They will be happy to help resolve any issues you experience.

Related Articles

How To Use The MySQL Database Wizard
How To Backup Your Database Using PHPMyAdmin
Connecting To MySQL Remotely
Importing Large MySQL Databases In SSH
How To Restore An SQL Database In cPanel

Can’t Find what you need?

No worries, Our experts are here to help.