Hosting Tutorial & Guide

What Is phpMyAdmin & How to Manage MySQL Database Using phpMyAdmin

updated on Aug 13, 2017
What Is phpMyAdmin & How to Manage MySQL Database Using phpMyAdmin Recently, we have received more than 100 emails from our readers asking what phpMyAdmin is and how to manage MySQL database using this tool. To provide them with a comprehensive definition and detailed steps, we have read the information at the official site of phpMyAdmin, checked a pile of articles, and tried to manage our MySQL database by using phpMyAdmin.

In the following parts, we have written down the main information about phpMyAdmin and the method to manage MySQL database using it.

What Is phpMyAdmin?

According to the articles we browsed and the information we read over the Internet, phpMyAdmin is a free software that is written in PHP to manage the administration of MySQL over the web. Because it supports many operations on MySQL, MariaDB and Drizzle, you are able to use it to manage databases, columns, tables, indexes, users, and much more. At the same time, you are allowed to execute any SQL statement directly.

Up to now, translated into 72 languages, phpMyAdmin is a 15 years old project that has won several awards. Moreover, it supports for most MySQL features, such as MySQL users and privileges management, stored procedures and triggers management, maintenance of server, tables and databases, executing, editing and bookmarking any SQL-statement, and so on.

In below, we have listed some of its highlighted features.
  • It has a user-friendly and intuitive user interface with little learning curve, meaning that people can use and get used into the functions easily and quickly.
  • It allows users to perform most of the MySQL functions, including managing database, running MySQL queries, executing SQL statement, managing users and permissions, and many more.
  • It can import data and export data from and to different formats.
  • It is able to alter the stored data into any other formats with the help of pre-defined functions.
  • It can create PDF graphics for the database, along with some complex queries with the help of Query-by-example.

How to Get phpMyAdmin?

In fact, almost all the rich-featured web hosts include this tool into their control panels like BlueHost. In this case, you can do nothing but only go through your control panel to find out the icon of phpMyAdmin for utilization. Generally, the icon is located under the database section.

However, in the case that you need to install this tool manually, we have shown you the necessary steps in the following

Step One: Download and Extract phpMyAdmin Zip File

The latest version of phpMyAdmin is 4.7.3, and you can download the zip file from http://www.phpmyadmin.net/. After downloading, you can get a zip file with the name of phpMyAdmin-4.7.3-english.

To install this tool, firstly you need to extract the content of this zip file. Simply right-click the file and choose the extract all option. You can use any unzip tool you like, and you can also do this with the help of file manager included in the control panel.

Step Two: Install phpMyAdmin

Now, go to the unzipped folder that uses the same name as the downloaded zip file and double click to into it. Then, you can find another folder that is needed to be dragged into your document root folder. In fact, you can place the folder at anywhere you like to access phpMyAdmin, but if you want to open this tool directly via http://www.yourdomainname.com/PhpMyAdmin, then you’d better place it under the public_html/PhpMyAdmin folder of your account.

Here, we take phpMyAdmin-4.1.13-english in OS(C) > apache > htdocs, and rename it as “phpmyadmin” to make it easy to call from the browser. OK, phpMyAdmin has been installed successfully, but there are still a couple of configurations that we recommend.

Step Three: Make Some Configurations

Firstly, you can test the phpMyAdmin in your browser to figure out whether it can work properly. Open your browser, and type http://localhost/phpmyadmin/. If you only see a list of files, then you need to make a few configurations in your web server, but not in PHP or phpMyAdmin.

Now, you can go to your httppd.conf file from OS(C) > apache > conf, and search for the string of index.html. This takes you to an option named as DirectoryIndex. Then, change the index.html to index.php.

After that, you can refresh your Services control panel to restart the web server. Then, go back to your browser and refresh. Now, you can see the phpMyAdmin login screen that requires you to enter the username and password to enter the user interface.

How to Manage MySQL Database Using phpMyAdmin?

Manage MySQL Database Using phpMyAdminphpMyAdmin is a graphic tool for creating and managing MySQL databases. The interface is easy to use and straight-forward. Free and open-source, this tool allows users to download it to execute SQL queries manually. In this part, we have mainly listed the steps of managing your MySQL database by using phpMyAdmin.

First, you need to go through 2 steps to log into phpMyAdmin: log into your control panel and click the phpMyAdmin icon under the "Databases" heading. Note that it is not secure to give the web developers your control panel access data, so you should install a separate installation of phpMyAdmin for them. In this way, they can access it without logging into the control panel.

The next step is clicking the Databases link. After clicking that button, you will see a lot of data. Then, pick the one you intend to manage and click on its name. At this time, a new screen comes out, where you are able to see a list of database tables, the number of the records, the allowed actions with them, the storage engine, the tables' sizes, the collation and the overhead.

Then, if you click any of the tables, you are allowed to view and manage the data in each of those tables. The actions you may perform to the table you choose are browse, structure, search, insert, empty and drop. Read the following parts for details.

Browse

Only the tables with existing record are available to be browsed. Once you click the Browse icon, you can see a new window with the records list. Then, click the Pen icon you can edit the chosen records and change their values.

Structure

Manage MySQL Database Using phpMyAdmin - StructureIn the Structure screen you can see the database's table structure and the fields' names. Then, you are capable of browsing the folders' value by clicking the corresponding action icon. Besides, you can edit a field's structure or even delete a field. Moreover, different indexes can be defined, in which you can find the indexes assigned to the table and the fields for which they are set. Furthermore, you also have the ability to check the row statistics and space usage.

Search

If you want to make all the records with a field value visual, you need to select the fields you want to show firstly. Then, pick the Like operator and enter in the relevant field value. The next step is to click the Go button to see the results you have searched.

Insert, Empty & Drop

If you want to insert any record in your MySQL database table, you just need to use the insert action, fill in the relevant values, and click the Go button. Moreover, the Empty action allows you to delete the chosen database table by removing the data and keeping the empty table. Finally, you can delete the whole table and all its records through the Drop action.

Conclusion

According to the information above, it can be easily seen that phpMyAdmin is a useful tool helping users manage MySQL database effortlessly. On the market, there are hundreds of web hosts offering this toll, but only a few are worth going. According to our experience and thousands of customer reviews, the following three recommendations are the best companies providing phpMyAdmin. Note that each of these compnaies is awarded as the best Linux hosting.

Each of which offers a high level of technical support. Therefore, coming across any issue about this tool, users with the 3 companies are able to contact the professional support team to get instant help.