Install XAMPP to set up Apache, PHP, and MySQL easily; 2. Download phpMyAdmin and extract it to C:\xampp\htdocs\phpmyadmin; 3. Rename config.sample.inc.php to config.inc.php and set auth_type to 'config' or 'cookie' with appropriate credentials; 4. Start Apache and MySQL via XAMPP Control Panel and access phpMyAdmin at http://localhost/phpmyadmin; 5. Fix common issues by verifying file paths, enabling required PHP extensions, and ensuring MySQL is running; 6. Optionally secure phpMyAdmin by renaming the folder, setting a root password, and adding .htaccess authentication—this completes a successful phpMyAdmin installation on Windows.

Installing phpMyAdmin on Windows isn’t complicated, but it requires a few prerequisites since phpMyAdmin is a web-based tool that runs on a web server with PHP and MySQL/MariaDB support. Here’s a step-by-step guide to get it up and running.

1. Install a Web Server with PHP and MySQL (Use XAMPP or Manual Setup)

phpMyAdmin needs:

• A web server (like Apache)
• PHP
• MySQL or MariaDB

The easiest way is to use XAMPP, which bundles all three.

Option A: Use XAMPP (Recommended for Beginners)

1. Download XAMPP from http://ipnx.cn/link/91cbfe3225b01df1272fd0856ff2bece
2. Run the installer and install it in C:\xampp (default location)
3. Launch the XAMPP Control Panel
4. Start the Apache and MySQL modules

? Now you have a working environment.

Option B: Manual Setup (Advanced)

If you prefer to install components separately:

• Install Apache (e.g., from apachelounge.com)
• Install PHP (from windows.php.net) and configure it with Apache
• Install MySQL or MariaDB
• Ensure php-mysqli extension is enabled

This method is more complex and error-prone—XAMPP is faster and safer for most users.

2. Download phpMyAdmin

1. Go to the official site: http://ipnx.cn/link/f5e0906e0da1a657230cf930de854408
2. Click “Download” and get the latest stable version (choose the .zip for Windows)
3. Extract the ZIP file to your web server’s document root:
   • For XAMPP: C:\xampp\htdocs\phpmyadmin

? Tip: Rename the extracted folder from something like phpMyAdmin-x.x.x-all-languages to just phpmyadmin for simplicity.

3. Configure phpMyAdmin

1. Inside C:\xampp\htdocs\phpmyadmin, look for config.sample.inc.php
2. Make a copy and rename it to config.inc.php
3. Open config.inc.php in a text editor (like Notepad or VS Code)

Find this line:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Ensure it’s set to:

$cfg['Servers'][$i]['auth_type'] = 'config'; // or 'cookie' if you want login prompt

If using config, you can add:

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';

? For security, 'cookie' is better—it prompts for username/password.

4. Access phpMyAdmin in Your Browser

1. Make sure Apache and MySQL are running (via XAMPP Control Panel)
2. Open your browser and go to:

   http://localhost/phpmyadmin

If everything is set up correctly, you’ll see the phpMyAdmin login screen (if using auth_type = cookie) or be logged in automatically (if using config with root).

Common Issues & Fixes

• 404 Error? Double-check the folder name and location: must be in htdocs and spelled correctly.

• Blank page or error? Check PHP extensions:

  • Open C:\xampp\php\php.ini
  • Make sure these extensions are enabled:

    extension=mysqli
    extension=mbstring
    extension=openssl

  • Restart Apache after changes.

  • "Cannot log in to the MySQL server"?

    • Verify MySQL is running
    • Reset root password via XAMPP if needed (using xampp/mysql/bin/mysql -u root -p)

  ---

  Optional: Secure phpMyAdmin (Recommended)

  • Change the default folder name from phpmyadmin to something less guessable
  • Set a password for the root user if it’s blank
  • Consider adding .htaccess authentication for the folder

  ---

  That’s it! You now have phpMyAdmin running on Windows. It’s a powerful tool for managing MySQL databases through a user-friendly web interface.

  Basically: install XAMPP → drop phpMyAdmin in htdocs → configure → access via browser. Not hard once you know the steps.

  The above is the detailed content of How to install phpMyAdmin on Windows. For more information, please follow other related articles on the PHP Chinese website!