In this tutorial you can learn how to install phpMyAdmin on Windows 10. PhpMyAdmin is an open-source software, designed to handle the management of MySQL databases through a graphical user interface.
Prerequisites
To install and use phpMyAdmin a local web server must be configured and running properly. If you don’t have a local web server yet, follow our tutorial: How to setup Apache, PHP and MySQL on Windows 10.
In this tutorial we will use
- Apache 2.4 web server
- MySQL 5.7.1
- PHP 7.4
Installation steps
- Download the latest package from https://www.phpmyadmin.net/downloads/
- Unzip the downloaded file to C:\Apache24\htdocs\phpMyAdmin
- Rename config.sample.inc.php to config.inc.php
- Open the config.inc.php in a text editor and find this line
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */- Add a value of your choice (min. 32 characters long), for example
$cfg['blowfish_secret'] = 'HUtJc4w3PJH8j2IpIHO391kPhAQrsBgy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */- Save the config.inc.php file
- Make sure you have mbstring and mysqli PHP extensions enabledopen the php.ini file located in your php folder (C:\phpxx by default, where xx is the version number, e.g.: C:\php74)
- find the ;extension=mbstring line and remove the semicolon (;) from the beginning
extension=mbstring- do the same for the line ;extension=mysqli
- extension=mysqli
- save the php.ini file
- restart Apache service in Services (Windows key + R and type services.msc)
- Open http://localhost/phpmyadmin/ in your browser, log in with your root username and password
- There will be a message at the bottom of the screen which says that the configuration storage is not completely configured. PhpMyAdmin needs a database to work. To configure the storage, click Import at the top of the screen and select the create_tables.sql file from the C:\Apache24\htdocs\phpMyAdmin\sql directory
- Click Go at the bottom of the screen and the warning message should be gone
