phpMyAdmin Tutorials

---

• Features
• Database Management
• Create Table
• Repair & Optimize Database

Features Tutorial

phpMyAdmin is one of the most popular applications for MySQL database 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 WebHostingWorld clients can manage their MySQL databases through the pre-installed phpMyAdmin software which is integrated in cPanel.

1) phpMyAdmin Features

The main phpMyAdmin features are:
• Intuitive web interface
• Support for most MySQL features:
     o browse and drop databases, tables, views, fields and indexes
     o create, copy, drop, rename and alter databases, tables, fields and indexes
     o maintenance server, databases and tables, with proposals on server configuration
     o execute, edit and bookmark any SQL-statement, even batch-queries
     o manage stored procedures and triggers
• Import data from CSV and SQL
• Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others
• Creating complex queries using Query-by-example (QBE)
• Searching globally in a database or a subset of it
• Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

2) phpMyAdmin Administration

All hosting accounts on the webhostingworld servers come with pre-installed phpMyAdmin software. The application can be opened from cPanel -> phpMyAdmin tool.

With the help of this we can manage below mentioned topics
1) Database
2) SQL
3) Status
4) Export
5) Import
6) Settings
7) Variable
8) Charsets
9) Engines
10) Plugins

On the right side of the screen, in the Database server section you can find information about the MySQL server. The databases which you will manage are stored on the same server as the software and the hostname is - localhost.

In the other two sections - Web server and phpMyAdmin you can also see information regarding the MySQL server, the MySQL client and the phpMyAdmin version

In the middle part of the page, in the General Settings section, you can see the MySQL charset and you will be able to define the MySQL connection collation.

In the panel on the left side of the page you will see the list of the databases for which your cPanel user has privileges.



At the top of the page you can see different tabs which allow you to perform different actions.

Databases

In the Databases tab you will find a list with all the databases which can be managed through the cPanel user.



Once you click on a chosen database name, you can start managing that database.

You will see a table with the used collations, the number of the tables and the rows, the size of the data and the indexes, the total size and the overhead.

SQL

Using this tab you can perform a MySQL query towards the MySQL server. Just type in the query and click the Go button and the phpMyAdmin tool will execute the query and provide the results from it.

Status

In the Status tab you can find detailed information regarding the MySQL server since the last restart.



You can see the traffic handled by the MySQL server, the maximum number of simultaneous connections, the total number of connections, the failed and the aborted attempts, the total number of queries sent to the server and more related details.

Export

In the Export tab you can export your database tables content in different formats (CSV, SQL, PDF, Microsoft Excel, Microsoft Word, XML, and many more). You can select all the database tables or just pick some of them.



You can add custom comments in the header of the exported content. You can decide whether to export just the database structure, the data or both of them. You can export the database tables in a file and compress it or you can visualize the queries directly on the screen.

Import

In the Import tab you can import database tables from a file, saved on your local computer.



You can browse for the file to import and pick its character set from the drop-down menu.

If the file is too big, the MySQL server timeout can be reached. In such a case you can interrupt the import action. Then you can continue with the data import defining the number of the queries to be skipped from the file beginning. In this way you will skip the imported queries and continue from the point of the interruption.

Additionally you can pick the SQL server mode of the imported file.

Settings

In the Settings tab you can configure phpMyAdmin the way you want it to.



You can customize what information to see in the different panels on the different pages, change the default preselected options on the Import and Export tabs and much more.

Variables

In the Variables tab you can see all the current MySQL variables and their values.



You can use the Edit button next to each of the variable names to edit the values of the variables. Note that you may not be able to change all the variable values as this is allowed only with the root user on the server.

Charsets

In the Charsets tab you can find all the charsets and collations supported by the MySQL server.

Engines

The Engines tab opens a page with a list of all the engines supported by the MySQL server. The default one is MyISAM. Another popular storage engine, used by many databases is InnoDB.

Plugins

The Plugins tab shows a list of all currently installed MySQL plugins and information about them like description and version.