How to Install phpMyAdmin on Your Windows PC

The phpMyAdmin is open-source software. Further, it is useful for MySQL database management & administration. So, it has many benefits for the users. But, many users don’t know ‘How to Install phpMyAdmin on Your Windows PC?’. Thus, we are ready here. We are providing detailed information regarding the same. We assure you that this will definitely help you in many ways. You should make use of it for your system also. So, let’s have a look at this informative tutorial ‘How to Install phpMyAdmin on Your Windows PC?’.

How to Install phpMyAdmin on Your Windows PC?

With the help of this software, you can manage all the records. Moreover, the efficient use it is for database related operations. So, it becomes necessary to know about ‘How to Install phpMyAdmin on Your Windows PC?’. No doubt, it will provide you with many advantages. So, you should adhere to this thorough information. On the other hand, you should prepare your mind to grab this opportunity.

Pre-requirement for the system

You should take care of some pre-requirements to install this software. There should be a web server running like Apache & database manager as MySQL along with PHP. So, with these basic requirements, you can go further into the installation process.

Process Used to Install phpMyAdmin on Your Windows PC

There is a certain process used for this target. You should follow the steps given below to do so.

Step – 1 ) Visit the Official Apache Website

The first thing you should do is to visit the Apache official website. (https://www.phpmyadmin.net/)

How to Install phpMyAdmin on Your Windows PC step 1

Step – 2 ) Click on the ‘Download’ Option

After that, you should click on the ‘Download’ option on the window displayed.

downloading window to Install phpMyAdmin

Step – 3 ) Select the ‘Close’ Option

Further, click on the ‘Close’ option when the window pops up. In addition, it is a message regarding downloading the files.

closing window display

Step – 4 ) Open the phpmyadmin Folder

Now, double-click on this downloaded folder to view all the content. Then, select all folders & data in this main folder & do copy them.

folder copying window

Step – 5 ) Paste the Data in the Right Place

Moving ahead, follow the path ‘Local Disk (C:) > Apache > htdocs’ to execute this operation. after that, right-click there & choose the ‘Paste’ option to fulfil it.

destination selection window

Step – 6 ) Rename the Folder

In addition to the above, now, rename the folder as ‘phpmyadmin’.

Step – 7 ) Open the PHP Folder

You should open the PHP folder now to move further. So, double-click on the ‘PHP’.

PHP folder window
Image Source: wikihow

Step – 8 ) Rename the ‘php.ini-production’ File

Now, Rename the ‘php.ini-production’ file as ‘ph.ini’. This is very important step to perform.

renaming PHP file window
Image Source: wikihow

Step – 9 ) Select the ‘Notepad’ Option

Double-click on the ‘php.ini’ folder. Then, choose the ‘Open with’ option. After that, select the ‘Notepad’option to perform necessary operations.

notepad selection window

Step – 10 ) Finding the “extension=php_mbstring.dll” Line

Next to the above step is to find the “extension=php_mbstring.dll” line. In fact, to search this line, you should press the ‘Ctrl + F’ keys together. This will lead to the ‘Find’ window. then, you can put the above line without a semicolon to search.

Image Source: wikihow

Step – 11 ) Finding the “extension=php_mysqli.dll” Line

Moreover, you should find the “extension=php_mysqli.dll” line by making use of the find window as above. After doing all these things, save your changes. Now, your server is okay for moving ahead. You can exit from the notepad application you are using so far.

Image Source: wikihow

Step – 12 ) Open the ‘Command Prompt’ Window

Now, you should open the ‘Command Prompt’ window to go ahead. Search in the search bar for ‘cmd’ for that.

command prompt icon window

Now, right-click on that & select the ‘Run as administrator’ option.

In the window, add the ‘cd /Apache24/bin’ (‘Apache24’ can be replaced with the folder name in your computer) command & press the enter key. After that, add the ‘httpd -k restart’ commnd & again press the enter key.

Step – 13 ) Testing Phase

Now, it’s the time to test. So, put ‘http://localhost’ in the new window of your browser & go for testing.

testing window
Image Source: wikihow

In this way, following the above-mentioned steps, you can install phpMyAdmin on your Windows PC.