phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.
You can download phpMyadmin at http://www.phpmyadmin.net/home_page/downloads.php You can choose from ‘All Languages’ or ‘English’ versions
The latest version (currently 3.2.5) is found at the top of the page.
In this guide we will download the English zip file, which can be easily extracted on a Windows 7 machine without additional downloads.
Once you have doenloaded the zip file and turned off any antivirus or firewall you are ready to start
Open the folder you downloaded to and right click and click Extract All…
Select a destination folder.
I have used the default folder which is the same folder the zip file was downloaded to
Click on Extract
Screen shot below shows file being extracted by Windows 7
Open the location where you extracted the file
Open the folder phpMyAdmin-X.X.X-english (where X is the version number)
The file you find in there will have the same file name.
You need to rename it phpmyadmin
Right click the renamed file and Copy it to clipboard – right click and select Copy from list
Navigate to your web server root (C:\Inetpub\wwwroot) and paste the file there
Open the phpmyadmin folder you pasted and create a new folder and name it config
Now close all open folders
Open your Browser and type http://localhost/phpmyadmin/setup/index.php
This opens the configuration page
Ignore the security warnings as they are intended for server administrators installing phpMyAdmin on an internet server
On the bottom of the page click on New Server
You are required to set up the php configuration for your computer as follows
Check the following settins, some of which are entered by default
Server hostname: localhost
Connection Type: tcp
PHP extension to use: mysql
Authentication type: config
User for config auth: root
Password for config auth: Your MySQL root password
Scroll down and click Save
The phpMyAdmin Overview page opens
Ignore any warnings
Under Servers ensure localhost appears under Name
Now close browser
Navigate to your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)
Open the config folder
Right click and copy the file config.inc
Paste the config file to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)
The official instructions instruct you to delete the config folder, however this is not necessary in a local testing environment
Close all folders
Open Web Browser and type in http://localhost/phpmyadmin/ to start setting up your databases
Congratulations! – you have now created a PHP development environment.
NOTES: If you can not connect to MySQL and receive an error message from http://localhost/phpmyadmin/ it is more than likely an error in config.php file
Click here to download a very basic text file example
Go to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) and open config file & compare to downloaded sample
The only modification required is changing the password in file & save to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) with file name config.php as a text file
It would be prudent to first rename the existing config file configOLD.php prior to saving file, just in case you need it later.
There is a more detailed sample file already in your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) that can also be used called config.sample.inc.php (just rename config.inc.php)