phpmyadmin windows

How to Install phpMyAdmin on IIS in Windows 8/Server 2012


PHPMyAdmin is a web-based open source tool written in PHP designed to help manage MySQL database through the Web browser. Because of this PhpMyAdmin facilitates the management and maintenance of the MySQL database. PhpMyAdmin provides an easy way to use graphic interface to write and execute queries, manage users and databases, to export and import data, etc. It should be noted that user does not need to know SQL commands and use them directly. Most web hosting providers use phpMyAdmin to access their clients to MySQL databases. In this article we will take a look on how to install phpMyAdmin on IIS in Windows Server 2012.

How to Install phpMyAdmin on IIS

In this article, we will show you how to install and configure phpMyAdmin on IIS Web Server on Windows 8 / Windows Server 2012. It assumed that you have already configured IIS with PHP support and run mySQL.

First of all you have to download the latest version of phpMyAdmin. You can do this from the link below:

https://www.phpmyadmin.net/downloads/

You should download a file with all languages (the file name ends with *all-languages.7z or *all-languages.zip). File size is about 5 MB.

Extract the files from the archive to phpmyadmin folder (C:\inetpub\wwwroot\phpmyadmin).

READ ALSO  Windows Server 2012 Mailbox Role Process Execution Failed Exit Code 15010

In general, we have completed the installation of phpMyAdmin. Now we should open a browser and make sure that we did installation correct. Visit http://localhost/phpmyadmin/ and you will see a window like this:

install phpmyadmin on IIS

Now we have to configure phpMyAdmin. Before you connect to the SQL server, you should create a configuration file. This file can be created manually (simply use a text editor), but we will use another method (by using GUI). Visit http://localhost/phpmyadmin/setup/ in your browser.

During your first session you will see an error message.

phpmyadmin IIS

To solve this problem you should create folder (C:\inetpub\wwwroot\phpmyadmin\config). After that give full rights for IIS_IUSRS group and IUSR user.

phpmyadmin windows server 2012

Return to the config window. To configure the connection settings click on the “New Server” button.

new phpmyadmin windows server 2012

Enter the verbose name of the SQL server, and then the server hostname. If necessary, you can specify other settings.

add phpmyadmin windows server 2012

Save the settings and then the server will redirect us to the previous page. Choose:

  • the default language – English
  • the default server – 127.0.0.1
  • end of the line – Windows (\ r \ n)

phpmyadmin for IIS

Click Save, and then download. The received file (config.inc.php) you should save to the root directory (C:\inetpub\wwwroot\phpmyadmin).

Open the authorization window (http://localhost/phpmyadmin/) and login under root account. If you see a starting phpMyAdmin window, you can delete config folder.

READ ALSO  Hack tricks: Acquiring Administrative Access to Windows

For the correct work phpMyAdmin requires a database with the information. The script for creating database is already installed. On the main page click on the Import tab and then click on the Browse button. Select the C:\inetpub\wwwroot\phpMyAdmin\examples\create_tables.sql file and click Go.

If you did it correct, you should see a new database in the left section.

Also, for a proper work phpMyAdmin requires a dedicated MySQL account.

phpmyadmin for IIS new user

We recommend you to create account like this:

  • User name: pma
  • Host: localhost
  • Password: sTr0ngPmapa $$

After that you should grant all database privileges to our user.

install phpmyadmin IIS privileges

Finally, you have to uncomment / add lines in config.inc.php:
$cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
$cfg[‘Servers’][$i][‘controlpass’] = ‘sTr0ngPmapa$$’;

And that’s it. We have completed to install phpMyAdmin on IIS in Windows Server 2012. Now you can proceed with the databases management. If you encounter any issues or have any questions you may request that in the comment section below.


You may also like:

Deploy LGPO with MDT 2013 Local Group Policy (LGPO) of computer is configured through gpedit.msc snap-in, which does not provide the possibility to export/import settings. That...
How to Fix Can’t Connect to Proxy Server on ... In this article we are going to find out how to fix annoying problem on Windows 10. When you try to go in Web, it says Can’t connect to the proxy serv...
How to Setup FTP Server in Windows 10 Nowadays the FTP technology is awesome and we decided to show how to setup and access an FTP server in Windows 10 in a simple way. How to create FTP ...
How to Create Bootable USB Drive from WinRE.wim Fi... In this article we will show you how to create a bootable USB drive with WinRE.WIM file using the standard Windows tools. Boot into WinRE environment ...
How to Recreate Virtual Directories OWA and ECP on... This article describes how to recreate virtual directories OWA and ECP on Exchange 2016. The rebuilding of these virtual directories helps to reset al...