--- title: 'How to install and configure phpMyAdmin on Windows Server | Zomro' description: 'phpMyAdmin is a well-known web application for working with MySQL (MariaDB) databases. It is a set of PHP scripts running under the control of a web server. phpMyAdmin gr' image: 'https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/01/image-20230702024817-2.jpg' --- ![opened image]() * [Zomro](https://zomro.com/) * [FAQ](https://zomro.com/blog/faq/) * How to install and configure phpMyAdmin on Windows Server # How to install and configure phpMyAdmin on Windows Server 29-06-2023 With phpMyAdmin you can create, configure, edit, delete databases and database objects on a server running MySQL. For the web application phpMyAdmin to work, the server must already have the IIS web server running in conjunction with PHP and the MySQL database server installed and configured. If these applications are not installed, you can use the following instructions: [How to install and configure PHP on Windows Server](https://zomro.com/blog/faq/363-how-to-install-and-configure-php-on-windows-server), [How to install and configure the IIS web server on Windows Server](https://zomro.com/blog/faq/349-kak-ustanovit-i-nastroit-vebserver-iis-php-i-mysql-na-windows-server), [How to install and configure MySQL on Windows Server](https://zomro.com/blog/faq/349-kak-ustanovit-i-nastroit-vebserver-iis-php-i-mysql-na-windows-server). ## How to install PHP on Windows Server. For all of the following steps, it is assumed that the IIS, PHP, and MySQL programs are already installed and running. Let's get started with the installation. 1\. In the folder C:\inetpub\wwwroot, create a folder called phpmyadmin ![How to install and configure phpMyAdmin on Windows Server - 1](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/01/image-20230702024817-2.jpg) 2\. Go to [Download phpMyAdmin](https://www.phpmyadmin.net/downloads/) and download the multi-language package *.all-languages.zip ![How to install and configure phpMyAdmin on Windows Server - 2](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/01/image-20230702024533-1.jpg) 3\. Unzip the downloaded archive into the previously created folder C:\inetpub\wwwroot\phpmyadmin ![How to install and configure phpMyAdmin on Windows Server - 3](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/01/image-20230702025958-3.jpg) 4\. Installation is complete. Open the page http://localhost/phpmyadmin/, you should see the standard phpmyadmin panel login form ![How to install and configure phpMyAdmin on Windows Server - 4](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710232928-2.jpg) 4.1 _Installation Note._ At this point, when you open the page http://localhost/phpmyadmin/, the following errors may occur: 4.1.1 Error 1. Handler not found. The error page looks like this: ![How to install and configure phpMyAdmin on Windows Server - 5](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710233412-3.jpg) Solution: create a php file handler for the web server. The screenshots below show how this can be done. ## How to configure PHP on Windows Server. ## ![How to install and configure phpMyAdmin on Windows Server - 6](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710235854-9.jpg) ![How to install and configure phpMyAdmin on Windows Server - 7](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710234120-5.jpg) 4.1.2 Error 2. PHP extension (module) not found. For example, mysqli (as in the screenshot) ![How to install and configure phpMyAdmin on Windows Server - 8](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710234515-6.jpg) Solution: enable the required extension in the php.ini file and restart the IIS web server. The php.ini file is located in the folder where PHP was previously installed (in our example it is C:\php\\). To enable the extension you need, you need to find it by name in the php.ini file and uncomment (remove the ;; character from the beginning of the line) the line with the extension name. ![How to install and configure phpMyAdmin on Windows Server - 9](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710235207-7.jpg) After saving the php.ini file, you must restart the web server ![How to install and configure phpMyAdmin on Windows Server - 10](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/07/10/image-20230710235419-8.jpg) 5\. In the root phpmyadmin folder, you need to find the config.sample.inc.php file and rename it to config.inc.php. Next, open config.inc.php in Notepad or another text editor (Notepad++ is recommended) and uncomment (remove the // characters from the beginning of the line) the following lines: > $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; > $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; > $cfg['Servers'][$i]['relation'] = 'pma__relation'; > $cfg['Servers'][$i]['table_info'] = 'pma__table_info'; > $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; > $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; > $cfg['Servers'][$i]['column_info'] = 'pma__column_info'; > $cfg['Servers'][$i]['history'] = 'pma__history'; > $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; > $cfg['Servers'][$i]['tracking'] = 'pma__tracking'; In addition, replace the word localhost with 127.0.0.1 ![How to install and configure phpMyAdmin on Windows Server - 11](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801130509-1.jpg) Save the config.inc.php file. 6\. In your browser, go to http://127.0.0.1/phpmyadmin and log in with the root user credentials whose password was created during installation on the MySQL server. ![How to install and configure phpMyAdmin on Windows Server - 12](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801130741-2.jpg) ![How to install and configure phpMyAdmin on Windows Server - 13](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801130813-3.jpg) 7\. To store service information, phpmyadmin uses its own database, which we will now create. We will also create a user with full rights to this database. To create the database, we will use a ready dump provided by the developers in the file create_tables.sql. This file is located in the sql subfolder. To import this dump, from the main phpmyadmin page, go to the Import tab ![How to install and configure phpMyAdmin on Windows Server - 14](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801131700-4.jpg) ![How to install and configure phpMyAdmin on Windows Server - 15](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801131802-5.jpg) select the file create_tables.sql ![How to install and configure phpMyAdmin on Windows Server - 16](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801132321-1.jpg) Click the Import button (at the very bottom of the form) and wait for the database import to complete. The phpmyadmin database should now appear in the list . ![How to install and configure phpMyAdmin on Windows Server - 17](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801132350-2.jpg) Now let's create a MySQL account and grant permissions to the database we just created. To do this, go to the phpmyadmin database and click on Privileges - Add user / Add user account ![How to install and configure phpMyAdmin on Windows Server - 18](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801132438-3.jpg) Fill in the form fields as indicated in the screenshot ![How to install and configure phpMyAdmin on Windows Server - 19](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801132524-4.jpg) In the config.inc.php file, you need to uncomment the lines and write the access data of the previously created user pma > $cfg['Servers'][$i]['controluser'] = 'pma'; > $cfg['Servers'][$i]['controlpass'] = 'pmapass'; pmapass is the password for user pma ![How to install and configure phpMyAdmin on Windows Server - 20](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/08/01/image-20230801132630-5.jpg) In this article we learned how to install phpmyadmin on Windows Server. Similar articles: [Checking the baud rate using the iperf3 utility](https://zomro.com/blog/faq/338-proverka-skorosti-peredachi-dannyh-pri-pomoshi-utiliti-iperf3) [Increasing traffic](https://zomro.com/blog/faq/715-increasing-traffic) [Domain transfer to another user on the same server with VestaCP/HestiaCP](https://zomro.com/blog/faq/386-domain-transfer-to-another-user-on-the-same-server-with-vestacphestiacp) [Installing the Pterodactyl Control Panel (Ubuntu)](https://zomro.com/blog/faq/358-installing-the-pterodactyl-control-panel-ubuntu) [How to install MySQL 8 in Docker](https://zomro.com/blog/faq/291-kak-ustanovit-mysql-8-v-docker) [ Premium Cloud VPS from €7.95/mon ](/premium-vps)