Home PHP Graphics ASP JavaScript HTML JAVA Swing Webtip Lyric Free sheet music Ringtones

Install PhpMyAdmin on Windows XP professional

phpMyAdmin is a popular and free PHP application used for administering one or more MySQL servers. Although this instruction focuses on Windows XP(IIS), you may find helpful hints for setting phpMyAdmin with Apache.

The instructions on this page will show you how to:

Download and install the latest version of PHP
Download and install the latest version of MySql;
Download and install the latest version of phpMyAdmin.
Configure phpMyAdmin and PHP so that it can connect to your MySQL server.

Note: You must install and start your MySQL server before you can use phpMyAdmin.

Download and install PHP.

First, follow the link: install PHP on windows to install PHP(Where php version is 5.0).

Second, in order to connect to MySQL, modify php.ini like the following :

find: ;extension=php_mbstring.dll, remove ; and become extension=php_mbstring.dll

find: ;extension=php_mysql.dll, remove ; and become extension=php_mysql.dll

These are 2 DLLs needed by MySql.

find: extension_dir = "./", change it to extension_dir = c:\php\ext (Assume you use Php 5.0, if not, add path to your extension directory)

Third, in order to let Windows XP system use the php.ini under (c:\php), you need set up an environment variable: PHPRC, which value is c:\php. Please following this instructions to set up environment variable in windows XP.

Open Control Panel, double click on system, Click on "Advanced" Tab, click on "Environment Variables", click on "New" button in popup window, input "PHPRC" for variable name, input "c:\php" for variable value. Click several OKs to close all the windows.

Finally, Shutdown and restart IIS. Whenever you make change to php.ini, you need to shutdown and restart IIS to make changes available.

Open a DOS console window, type following command:
Shut down IIS server -- (net stop iisadmin)
Restart IIS -- (net start w3svc)
Or reboot your PC.

To check if your PHP is ready to connect to MySQL, copy the following code to a file and saved as test.php under c:\inetpub\wwwroot.

<?php
phpinfo();
?>

Open a browser, type : http://localhost/test.php. You should be able to see the following contents. It is your PHP configure about MySQL.

`Download and install MySQL.`

First, download MySQL 5.0.13. In this instructions, we download Zip Archive without installer for simplicity.

Second, Extract the archive to the desired install directory, c:\mysql.

Note: Some Zip archive tools may extract the archive to a folder within your chosen installation location. If this occurs you can move the contents of the subfolder into the chosen installation location. For example, your folder may like this c:\mysql\mysql-5.0.13. If so, you need move everything under mysql-5.0.13 to c:\mysql.

Finally, Start your MySQL server. Open a DOS console window, go to c:\mysql\bin, type: mysqld --console.

Download and install phpMyAdmin

First, download phpMyAdmin 2.6.4-pl1.

Second, extract Zip archive to a directory under c:\inetpub\wwwroot, like c:\inetpub\wwwroot\phpadmin.If you prefer to install it in other directory, such as d:\phpadmin, you need set up a virtual_directory to it. Following this instruction to set up a virtual directory.

If you used other MySQL archive and set up password for root, you need change config.inc.php like this.

Finally, it is time to use phpMyAdmin. open a browser, type: http://localhost/phpadmin/index.php, you should be able see the following window:

The red words in the above window is " Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."

It reminds you that you didn't have a password for root account. You may set up a password for your root account in MySQL like this:

Open DOS console window, go to c:\mysql\bin.
Type: mysql -u root, press Enter.
Under prompt mysql>
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('passwd');
Note, you need put your real password instead of passwd
After you change the password for root, you need change config.inc.php in c:\inetpub\wwwroot\phpadmin.

Open config.inc.php in your desired editor, find: $cfg['Servers'][$i]['password'] = '';

insert your password in the above ''. Save your config.inc.php.