PhpMyAdmin

PhpMyAdmin: a free open source tool written in PHP to handle the administration of MySQL using a web browser. Want to know how to install it? Follow the simple steps below!

Note: Before you install phpMyAdmin open the php.ini file (See PHP Installation Tutorial if this file is not present in C:\PHP) and ensure you have uncommented and thereby activated these two extensions:

1. extension=php_mysqli.dll
2. extension=php_pdo_mysql.dll

Step 1: Download PhpMyAdmin

Navigate to https://www.phpmyadmin.net/downloads/

For the sake of consistency across the company we will be downloading phpMyAdmin 4.6.4 and we would like a zip file, assuming the company is primarily English we will download the English only version. In Figure 4.1 below, this is the last option in the list. Click on the file name to begin the download, a window will appear thanking you for downloading and asking if you'd like to donate, simply hit close if you do not wish to make a donation.

Figure 4.1 List of downloadable phpMyAdmin files

Step 2: Extract contents

Upon completion of the download extract the files into the folder where you would like to use phpMyAdmin. I will be using my ashleyhasler.com virtual host configured in the previous tutorial on Apache.

In C:\Apache24\htdocs\ extract Apache into the root of the virtual host you would like to use it with. You can put it in the root of htdocs however, for the sake of this tutorial place it in the firstName+lastName folder you have previously made. In my example I placed it in C:\Apache24\htdocs\ashleyHasler

Step 3: Test if it works!

Start your Apache server by opening ApacheMonitor and once the icon displays a green light visit: firstName+lastName.com/phpMyAdmin, in my case this would be ashleyhasler.com/phpMyAdmin.

If your screen is similar to the one in Figure 4.2 then the installation was successful!

Figure 4.2 phpMyAdmin was successfully installed.

Step 4. Login

To login you will use the user root explained in the MySQL Community Server Installation blog and the password that you set in that blog. If you are successful your screen should look similar to Figure 4.3

Figure 4.3 You have successfully logged in!