Part 6 - Installing PHPMyadmin

6.0 Installing and configuring PHPMyadmin

1. Extract the downloaded file into E:\ server\.
2. Change the folder name from phpMyAdmin-2.6.2-pl1 to phpmyadmin or any other name you like.
3. If you had followed step by step from the tutorial, your E:\server directory will look like this.
   E:\server
   +Apache2
   +mysql
   +php
   +phpmyadmin
   +www --> default directory
4. Because phpmyadmin folder is outside of our default directory, we cannot display or get any files or information from this folder when we typed http://localhost/phpmyadmin.
5. Now, open httpd.conf file.
6. Add this line:
   Alias /phpmyadmin "E:/server/phpmyadmin/"
   
   Order deny,allow
   Deny from all
   Allow from 127.0.0.1
   
7. The first line is to point /phpmyadmin as E:/server/phpmyadmin/, so every time we type http://localhost/phpmyadmin, we will be point to E:/server/phpmyadmin.
8. Line in is for security reason. Phpmyadmin can only be open by localhost which have IP 127.0.0.1. (This IP if I’m not mistaken is especially for localhost, so other computer cannot open this directory).
9. Restart your Apache2.
10. Open your browser and type http://localhost/phpmyadmin, http://127.0.0.1/phpmyadmin, http://***.***.***.***/phpmyadmin (type your ip address).
11. Previously, we had assign a password for our MySQL database. We cannot connect phpmyadmin to our database because by default phpmyadmin assume our administrator user ‘root’ has no password.
12. Now we need to edit config.inc.php located in phpmyadmin folder, again by using our powerful notepad. If you can’t find this file, try to search config.sammple.inc.php and change to config.inc.php.
13. Make these changes:
    

    From	To
    $cfg['blowfish_secret'] = ' '; Only if you type auth_type=cookie	$cfg['blowfish_secret'] = '(type anything, ex. jhgjhUAsAGjJS)'

14. Log in using your mysql username and password.

.

Note : This guide is only a strip down version (no picture). For a complete guide please download this file. Only for personal webserver.

How to install Apache, MySQL PHP (Windows XP)