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 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?’. You can also check more How to Tutorials for better solutions.
Table of Contents
- How to Install phpMyAdmin on Your Windows PC?
- Pre-requirement for the system
- Process Used to Install phpMyAdmin on Your Windows PC
- Step – 1 ) Visit the Official Apache Website
- Step – 2 ) Click on the ‘Download’ Option
- Step – 3 ) Select the ‘Close’ Option
- Step – 4 ) Open the PHPMyAdmin Folder
- Step – 5 ) Paste the Data in the Right Place
- Step – 6 ) Rename the Folder
- Step – 7 ) Open the PHP Folder
- Step – 8 ) Rename the ‘PHP.ini-production’ File
- Step – 9 ) Select the ‘Notepad’ Option
- Step – 10 ) Finding the “extension=php_mbstring.dll” Line
- Step – 11 ) Finding the “extension=php_mysqli.dll” Line
- Step – 12 ) Open the ‘Command Prompt’ Window
- Step – 13 ) Testing Phase
How to Install phpMyAdmin on Your Windows PC?
With the help of this software, you can manage all the records. Moreover, the efficient use 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/)
Step – 2 ) Click on the ‘Download’ Option
After that, you should click on the ‘Download’ option on the window displayed.
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.
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.
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 fulfill it.
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’.
Step – 8 ) Rename the ‘PHP.ini-production’ File
Now, Rename the ‘PHP.ini-production’ file as ‘ph.ini’. This is a very important step to perform.
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.
Step – 10 ) Finding the “extension=php_mbstring.dll” Line
Next to the above step is to find the “extension=php_mbstring.dll” line. 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.
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.
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.
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’ command & again press the enter key.
Step – 13 ) Testing Phase
Now, it’s time to test. So, put ‘http://localhost’ in the new window of your browser & go for testing.
In this way, following the above-mentioned steps, you can install phpMyAdmin on your Windows PC.