At present, there are a lot of tools available online used to handle the administration of MySQL, among which phpMyAdmin is the most exceptional one. As a PHP based application with the use of the web browser, phpMyAdmin can help you interact with your MySQL database easily and effortlessly. In the following, we have introduced this script in detail, along with its benefits and installation tips.
What is phpMyAdmin?
In fact, phpMyAdmin is a MySQL database manager that is open source and free of charge. With it, users can achieve the operations on MySQL, such as creating, altering and removing databases, rows, tables, relations, indexes, fields, users, permission, and many more. Users are allowed to perform these operations via the user interface. Also, they can start any SQL statements directly.
Why Use phpMyAdmin?
Being created for more than 15 years with a stable code base, phpMyAdmin has been awarded as the best PHP script in many industry related awards, such as the SourceForge.net Community Choice Awards, Infoworld Award, and MySQL Community Awards, etc. What contribute to this great success and popularity? In the following, we have listed some of the excellent benefits you can get from phpMyAdmin.
- 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.1.13, 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.1.13-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 about phpMyAdmin User Interface?
Now, we’d like to describe the basic functions presented in the user interface of phpMyAdmin.
- Database – You can find a list of databases that can be managed easily.
- Status – You are allowed to find the detailed information related to the MySQL server since the latest restart.
- Variables – You can figure out a list of MySQL parameters.
- Charsets – You are able to get the charsets supported by your server.
- Engine – You can check the storage engines for your MySQL server, defaults to MyISAM.
- Processes – You can see all the processes running currently along with the detailed information.