PhpMyAdmin Tutorial

What is PhpMyAdmin?

PhpMyAdmin is one of the most popular applications for MySQL databases management. It is a free tool written in PHP. Through this software you can create, alter, drop, delete, import and export MySQL database tables. You can run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands.

All the SiteGround clients can manage their MySQL databases through the preinstalled PhpMyAdmin software which is integrated in cPanel. Check our PhpMyAdmin hosting for more details.

In this tutorial we will show how to use PhpMyAdmin and manage your MySQL databases through it.

The PhpMyAdmin tutorial covers the following topics:

• PhpMyAdmin Features

  A short list including the basic phpMyAdmin features.

• How to install PhpMyAdmin

  Easy to follow instructions how to perform phpMyAdmin installation for your hosting account.

• PhpMyAdmin administration

  Under this section of the PhpMyAdmin Tutorial we will describe the functionality of the software, integrated in cPanel.

• How to manage MySQL database tables with PhpMyAdmin

  Learn the basics of database management through phpMyAdmin

• How to create a database with PhpMyAdmin, add tables, backup and restore it

  In this part of our PhpMyAdmin tutorial we will describe the steps which must be followed in order to create a new database, add a table with records, create a database backup and perform a database restore from an existing backup.

• How to repair and optimize database tables with PhpMyAdmin

  In this part of our PhpMyAdmin tutorial we will show how to repair and optimize database tables through PhpMyAdmin.

• How to run MySQL query with PhpMyAdmin

  In the following part of our PhpMyAdmin tutorial we will show how to construct and run a MySQL query.

• PhpMyAdmin Operations

  Here you can find instructions about the operations that can be performed for a database via phpMyAdmin