KidsLovePC Contact Us
  Home   PHP  Graphics ASP  JavaScript   J2EE  HTML  JAVA   Swing   Webtip  Forums  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.


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 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 in c:\inetpub\wwwroot\phpadmin.

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

insert your password in the above ''. Save your

  • Reopen your phpMyAdmin in browser.
  • If you want phpMyAdmin accessible to remote machine, you need set like following

Find $cfg['PmaAbsoluteUri'] = '';

insert inside '' in the above.


PHP Calendar
Comprehensive PHP Web Calendar
Configurable PHP Calendar
PHP Calendar
PHP Image Processing
PHP grahic softwares
PHP create real-time dynamic chart
create antispam image(image verification)
Add water mark to image
PHP Image processing introduction
Add text on Image
Create thumbnail for image
Create image from text on fly
PHP code sample
PHP create dynamic PDF with FPDF
PHP create dynamic PDF with PDFLib
PHP create dynamic PDF with ClibPDF
Improved PHP configurable hit counter
Install phpMyAdmin,MySql, PHP
PhpMyAdmin export/import data
A simple PHP RSS feed reader
PHP include (SSI)
Working with Forms
PHP formmail Generator
Using phpMyAdmin Create Database
Insert Form Data into Database
Retrieve data from Database
Retrieve multiple records
Batch insert text using phpMyAdmin
Using phpMyAdmin insert binary file
Insert binary file using PHP code
Using form insert binary file into MySQL
Retrieve binary file from MySQL
Image hosting business in minutes
Send HTML mail in PHP
Send bulk emails in PHP
Polling/Rating System in PHP
Polling/Rating System in PHP(radio button)
Check visitor's IP address
Check reciprocal link
PHP tutorial
What is PHP?
Install PHP on Windows XP (part1)
Install PHP on Windows XP (part2)
PHP open and closing tags
PHP types
Logic Structures
Include files
Set cookie and delete cookie
Most often used MySQL functions




Printer Inkjet A Z lyricsLearn ChineseHome|PHP|Swing|HTML|JavaScript|ASP|JAVA|Forum|WebTip|Contact Us
Copyright © All rights reserved(new). Privacy|Copyright
designed by

Please help us cover the web site maintenance fee.
barcode scanner Thermal Printer credit card machine bar code printer