How to Install phpMyAdmin on Windows 10 with XAMPP or Manually

phpMyAdmin is a PHP web app, so it needs three things underneath it: a web server (usually Apache), PHP, and a MySQL or MariaDB database server. On Windows 10 the simplest route is XAMPP, a free bundle that already includes phpMyAdmin: install it, start Apache and MySQL in the XAMPP Control Panel, and open http://localhost/phpmyadmin. If you already run Apache and PHP yourself, the manual route further down adds phpMyAdmin to that setup.

Windows 10 support note: Windows 10 reached end of support on October 14, 2025. Consumer Extended Security Updates can cover a PC until October 12, 2027, and PCs on Windows 10, version 22H2 can upgrade to Windows 11 for free if the hardware qualifies (Microsoft’s end of support notice). Everything below works the same way on Windows 11.

What phpMyAdmin needs

According to the requirements page in the official phpMyAdmin documentation (docs.phpmyadmin.net), you need:

  • A web server such as Apache, nginx or IIS. This is the program that answers when your browser asks for a page.
  • PHP 7.2.5 or newer. The mbstring extension is strongly recommended, and openssl is strongly suggested because the default login method (cookie authentication) uses it.
  • MySQL 5.5 or newer, or MariaDB 5.5 or newer. MariaDB is a MySQL-compatible database, and phpMyAdmin treats it the same way.
  • A browser with cookies and JavaScript turned on.

Two terms come up a lot. localhost is the name your PC uses for itself, so http://localhost means “the web server on this computer”. The document root is the folder the web server publishes; in XAMPP and many Apache setups it is called htdocs.

Pick your route

Your situationBest route
Nothing installed yet; you want a local practice or development setupXAMPP (phpMyAdmin is included)
Apache, PHP and MySQL or MariaDB already installed and workingManual install of phpMyAdmin
A public website or a server other people reach over the internetNeither on a home PC; use your host’s control panel or a properly secured server

The XAMPP FAQ (apachefriends.org) says plainly that XAMPP is meant for development environments, not production use, because its defaults favor convenience over security.

Install phpMyAdmin with XAMPP

The Windows download on the official XAMPP site, apachefriends.org, bundles Apache, MariaDB, PHP and phpMyAdmin. You don’t need to download phpMyAdmin separately, which is the main thing older instructions get wrong.

  1. On apachefriends.org, open the download page and pick the Windows installer for the PHP version you want. If you have no reason to choose, take the newest one.
  2. Run the installer and select Yes at the User Account Control prompt. If a warning mentions User Account Control and the Program Files folder, select OK: it is a reminder to avoid installing there.
  3. On the components screen, make sure phpMyAdmin (and MySQL) are checked, then select Next.
  4. Keep the suggested folder, C:\xampp, and select Next until installation starts. The XAMPP FAQ warns that C:\Program Files can block writes even for administrators, so a folder at the root of C: avoids permission errors later.
  5. When setup finishes, leave the option to start the Control Panel checked and select Finish. The XAMPP Control Panel opens with a row for each server.
  6. Select Start next to Apache, then Start next to MySQL. Once a module is running, its name should be highlighted and its port numbers shown.
  7. Open your browser and go to http://localhost/phpmyadmin. The phpMyAdmin home page opens with your databases listed on the left.

The row says MySQL, but the database server XAMPP ships is MariaDB. For phpMyAdmin that makes no practical difference.

Give the root account a password

The XAMPP FAQ states that the database administrator account, root, has no password after installation. That’s acceptable only while nothing on the network can reach the PC. To tighten it:

  1. In phpMyAdmin, select User accounts at the top, find the root rows, and choose Edit privileges then Change password (labels can differ slightly between phpMyAdmin versions). Set a strong password and select Go.
  2. Open C:\xampp\phpMyAdmin\config.inc.php in Notepad. Find the line containing ['auth_type'] and set its value to 'cookie', then save.
  3. Reload http://localhost/phpmyadmin. You now get a login page; sign in as root with the new password.

Do step 2 promptly. If phpMyAdmin is still set to log in automatically with the old blank password, it shows an access denied error after step 1 until you change the setting.

Add phpMyAdmin to an existing Apache and PHP setup

Use this only if Apache, PHP and a database server are already installed and serving pages. Check these first:

  • The PHP manual (php.net) says Apache with mod_php needs the Thread Safe build of PHP, loaded with a LoadModule php_module line in Apache’s httpd.conf.
  • PHP on Windows needs the Microsoft Visual C++ runtime, matching PHP’s 32-bit or 64-bit build. Microsoft lists the current package on its Visual C++ Redistributable downloads page.
  • Your MySQL or MariaDB service is running, and you know a user name and password for it.
  1. Download the latest phpMyAdmin ZIP file from phpmyadmin.net. The documentation also explains how to check the download’s signature if you want to confirm it hasn’t been altered.
  2. Extract the ZIP, rename the extracted folder to phpmyadmin, and move it into Apache’s document root (the htdocs folder in a typical Apache for Windows install).
  3. Open your PHP folder. If there is no php.ini, copy php.ini-production and rename the copy to php.ini.
  4. Open php.ini in Notepad, use Ctrl + F to find the lines for mysqli, mbstring and openssl, and delete the semicolon at the start of each. Depending on the PHP version they read extension=mysqli or extension=php_mysqli.dll. Save the file.
  5. In the phpmyadmin folder, copy config.sample.inc.php and name the copy config.inc.php. Open it and put a random 32-character string between the quotes on the blowfish_secret line. Leave auth_type as 'cookie' so phpMyAdmin asks for a login.
  6. Restart Apache so it reads the new php.ini: restart the Apache service in Services, or run httpd -k restart from Apache’s bin folder in an administrator Command Prompt.
  7. Go to http://localhost/phpmyadmin/ and sign in with your database user name and password. The home page shows the server version and your databases.

phpMyAdmin also has a setup wizard at http://localhost/phpmyadmin/setup. It builds a configuration file for you to download and save yourself. The documentation recommends deleting the setup folder when you have finished.

When something doesn’t start or log in

Apache won’t start: port 80 is taken

Apache listens on port 80 by default, and only one program can use it. The XAMPP FAQ names Microsoft IIS and Skype as common culprits. To see what is holding the port, open Command Prompt and run netstat -ano, find the line ending in :80 under Local Address, and match its PID (process ID) to a program in Task Manager. Microsoft’s netstat reference explains each column. Then either close or stop that program, or move Apache:

  1. In the XAMPP Control Panel, select Config on the Apache row and choose Apache (httpd.conf).
  2. Find Listen 80, change it to Listen 8080, and save.
  3. Start Apache again and use http://localhost:8080/phpmyadmin from now on.

MySQL won’t start in XAMPP

The usual cause is another MySQL server already running on the database port, 3306, often left over from a separate MySQL install. Stop that service in Services, or uninstall it if you no longer need it, then select Start again. The log area at the bottom of the XAMPP Control Panel usually shows the error that stopped it.

Errors on the phpMyAdmin page

  • An error about the missing mysqli extension: PHP couldn’t load it. Recheck the extension= line in the php.ini that Apache actually uses, then restart Apache.
  • Login refused with a blank password, mentioning AllowNoPassword: phpMyAdmin blocks empty passwords by default. Give the account a password rather than switching the setting on.
  • “Access denied for user”: the user name or password doesn’t match the database server. In a manual install, check the account in the database; with auth_type set to config, check the stored password in config.inc.php.
  • A notice about the blowfish secret: the value must be a 32-byte string. Set one as described in step 5 of the manual route.
  • “Not Found” in the browser: the folder in htdocs doesn’t match the address. If you named it phpMyAdmin-5, either rename it or type that name in the URL.

Before and after you install

Can other computers reach my phpMyAdmin?

XAMPP’s FAQ says phpMyAdmin is reachable only from the PC itself by default. Keep it that way for a practice setup. If you ever expose phpMyAdmin, the official documentation recommends serving it only over HTTPS, adding a second login layer in front of it, and upgrading promptly when security releases come out.

Do I have to start XAMPP every time?

By default, yes: open the Control Panel and start Apache and MySQL when you want to work. The XAMPP FAQ notes that each server can also be installed as a Windows service, which starts it with Windows. For an occasional practice setup, starting them by hand uses fewer resources.

How do I check it worked, and how do I undo it?

A working install shows the phpMyAdmin home page, usually with a Database server panel listing the server type and version. Try creating a test database from the Databases tab, then drop it. To remove everything, stop all modules, uninstall XAMPP from the Apps list in Settings, and delete C:\xampp if anything is left; copy any databases you want to keep first by exporting them from phpMyAdmin. For a manual install, deleting the phpmyadmin folder from htdocs removes phpMyAdmin without touching your databases.

Should I set this up on Windows 10 or Windows 11?

Both work, but a PC on Windows 10 no longer gets regular security fixes. If you are rebuilding an old machine just for development practice and plan to stay on Windows 10 with Extended Security Updates, these notes on doing a clean install of Windows 10 cover backing up and starting fresh before you add XAMPP.