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
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.
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
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.
Open a browser, type : http://localhost/test.php. You should be
able to see the following contents. It is your PHP configure about
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,
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.
and install phpMyAdmin
First, download phpMyAdmin
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 config.inc.php in your desired
editor, find: $cfg['Servers'][$i]['password'] = '';
insert your password in the above ''.
Save your config.inc.php.
- Reopen your phpMyAdmin in browser.
- If you want phpMyAdmin accessible to remote machine, you need
set like following
Find $cfg['PmaAbsoluteUri'] = '';
insert http://www.yoursite.com/phpadmin/ inside '' in the above.