How to Install phpMyAdmin on Windows

This wikiHow teaches you how to install phpMyAdmin on Windows. You can use phpMyAdmin to control the MySQL server within a web browser, but first you need to set up a MySQL server on your computer. You can also use a free program called WAMP to automatically install phpMyAdmin on your server.

Table of Contents

Use the available Apache server

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ca/Install-phpMyAdmin-on-Your-Windows-PC-Step-1-Version-4.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ca/Install-phpMyAdmin- on-Your-Windows-PC-Step-1-Version-4.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-1-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Make sure you have Apache, PHP and MySQL installed. Apache, PHP, and MySQL must be installed and set up on your computer first before you can install phpMyAdmin this way.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3d/Install-phpMyAdmin-on-Your-Windows-PC-Step-2-Version-4.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-2-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3d/Install-phpMyAdmin- on-Your-Windows-PC-Step-2-Version-4.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-2-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the phpMyAdmin download page. Go to https://www.phpmyadmin.net/ on your browser.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fe/Install-phpMyAdmin-on-Your-Windows-PC-Step-3-Version-4.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-3-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fe/Install-phpMyAdmin- on-Your-Windows-PC-Step-3-Version-4.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-3-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the green Download button at the top left of the page. The phpMyAdmin ZIP folder will begin downloading to your computer.

You will also see the version number right next to the Download button (for example, with the November 2017 version of phpMyAdmin, you would click Download 4.7 .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bd/Install-phpMyAdmin-on-Your-Windows-PC-Step-4-Version-4.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-4-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bd/Install-phpMyAdmin- on-Your-Windows-PC-Step-4-Version-4.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-4-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Close when prompted to return to the phpMyAdmin website.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Install-phpMyAdmin-on-Your-Windows-PC-Step-5-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-5-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Install-phpMyAdmin- on-Your-Windows-PC-Step-5-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-5-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Double click the phpMyAdmin ZIP folder to open it.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b6/Install-phpMyAdmin-on-Your-Windows-PC-Step-6-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-6-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b6/Install-phpMyAdmin- on-Your-Windows-PC-Step-6-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-6-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Copy the contents of the phpMyAdmin folder. Click on the phpMyAdmin folder in the ZIP folder window, then press Ctrl + C .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6e/Install-phpMyAdmin-on-Your-Windows-PC-Step-7-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6e/Install-phpMyAdmin- on-Your-Windows-PC-Step-7-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-7-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Go to Apache’s home directory. This is usually a folder named “htdocs” located in the “Apache” folder on the “C:” drive.

The Apache home directory usually contains a text document named “index.php” or similar.
The fastest way to get to this folder is to click This PC on the left side of the window, double-click the Apache folder, and then double-click the htdocs (or similar) folder.

READ More: Susan B. Anthony

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b4/Install-phpMyAdmin-on-Your-Windows-PC-Step-8-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b4/Install-phpMyAdmin- on-Your-Windows-PC-Step-8-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-8-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Paste the copied folder into the home folder. Press Ctrl + V to paste the phpMyAdmin folder in the clipboard into the Apache home directory.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f8/Install-phpMyAdmin-on-Your-Windows-PC-Step-9-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f8/Install-phpMyAdmin- on-Your-Windows-PC-Step-9-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-9-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Rename the copied folder to phpmyadmin . Click on the phpMyAdmin folder, click Home , select Rename in the toolbar, type phpmyadmin in the folder name field, and then press ↵ Enter .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6c/Install-phpMyAdmin-on-Your-Windows-PC-Step-10-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6c/Install-phpMyAdmin- on-Your-Windows-PC-Step-10-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-10-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the PHP folder. This folder is located in the “C:” drive along with the “Apache” folder. After finding the PHP folder, double click to open it.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/Install-phpMyAdmin-on-Your-Windows-PC-Step-11-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fd/Install-phpMyAdmin- on-Your-Windows-PC-Step-11-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-11-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Find and rename the file “php.ini-production” to php.ini . ^{[1] X Research Source}

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/30/Install-phpMyAdmin-on-Your-Windows-PC-Step-12-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/30/Install-phpMyAdmin- on-Your-Windows-PC-Step-12-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-12-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Double click the “php.ini” file. The default text editor (such as Notepad) will open, however, you may need to select Notepad from the list and click OK first.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0c/Install-phpMyAdmin-on-Your-Windows-PC-Step-13-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0c/Install-phpMyAdmin- on-Your-Windows-PC-Step-13-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-13-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Find the line “extension=php_mbstring.dll” and remove the semicolon. You’ll see a semicolon to the left of this line of text.

Or, you can press Ctrl + F to bring up the “Find” window and then type this line of text to find it.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3f/Install-phpMyAdmin-on-Your-Windows-PC-Step-14-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3f/Install-phpMyAdmin- on-Your-Windows-PC-Step-14-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-14-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Find the line “extension=php_mysqli.dll” and remove the semicolon. Once done, the phpMyAdmin server is ready to be accessed.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8b/Install-phpMyAdmin-on-Your-Windows-PC-Step-15-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8b/Install-phpMyAdmin- on-Your-Windows-PC-Step-15-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-15-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Save changes and exit Notepad. Press Ctrl + S to save, then click the X in the upper right corner of the Notepad window to exit.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ed/Install-phpMyAdmin-on-Your-Windows-PC-Step-16-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ed/Install-phpMyAdmin- on-Your-Windows-PC-Step-16-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-16-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Run Apache server. Open Command Prompt in Administrator mode by right-clicking Start

{“smallUrl”:”https://www.wikihow.com/images_en/0/07/Windowsstart.png”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/07/ Windowsstart.png/30px-Windowsstart.png”,”smallWidth”:460,”smallHeight”:460,”bigWidth”:30,”bigHeight”:30,”licensing”:”<div class=”mw-parser-output “></div>”}

, click on Command Prompt (Admin) and then click Yes when prompted, then do the following:

Type cd /apache24/bin and then press ↵ Enter (replace “Apache24” with the name of the Apache directory).
Type httpd -k restart then press ↵ Enter .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/10/Install-phpMyAdmin-on-Your-Windows-PC-Step-17-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/10/Install-phpMyAdmin- on-Your-Windows-PC-Step-17-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-17-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Check out the program phpMyAdmin. Open a web browser, then type http://localhost in the address bar and press ↵ Enter . You will be taken to the phpMyAdmin login page.

Use WAMP

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/68/Install-phpMyAdmin-on-Your-Windows-PC-Step-18-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/68/Install-phpMyAdmin- on-Your-Windows-PC-Step-18-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-18-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Make sure you have MySQL installed. WAMP does not create the server itself, the program only allows you to interact with the server available on your computer.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Install-phpMyAdmin-on-Your-Windows-PC-Step-19-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Install-phpMyAdmin- on-Your-Windows-PC-Step-19-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-19-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}

Check your computer’s bit count to determine which version of WAMP to download.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9c/Install-phpMyAdmin-on-Your-Windows-PC-Step-20-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-20-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9c/Install-phpMyAdmin- on-Your-Windows-PC-Step-20-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-20-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the WAMP website. Go to http://www.wampserver.com/en/ on a web browser.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Install-phpMyAdmin-on-Your-Windows-PC-Step-21-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-21-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Install-phpMyAdmin- on-Your-Windows-PC-Step-21-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-21-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Scroll down and click WAMPSERVER 64 BITS or WAMPSERVER 32 BITS . Depending on your computer’s number of bits, click the appropriate option. Then a window will pop up.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Install-phpMyAdmin-on-Your-Windows-PC-Step-22-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-22-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Install-phpMyAdmin- on-Your-Windows-PC-Step-22-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-22-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the direct download link at the top right of the pop-up window. You will be taken to the Source Forge page to download the WAMP version.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Install-phpMyAdmin-on-Your-Windows-PC-Step-23-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-23-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Install-phpMyAdmin- on-Your-Windows-PC-Step-23-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-23-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the green Download button near the top of the page. WAMP will begin to download to your device.

Wait a few minutes for the program to finish loading.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/07/Install-phpMyAdmin-on-Your-Windows-PC-Step-24-Version-2.jpg/v4-460px- Install-phpMyAdmin-on-Your-Windows-PC-Step-24-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/07/Install-phpMyAdmin- on-Your-Windows-PC-Step-24-Version-2.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-24-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Install WAMP. Double-click the WAMP installation file and do the following:

Click Yes when prompted.
Select the language and then click OK
Check the “I accept the agreement” line and click Next
Click Next three times.
Click Install

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/15/Install-phpMyAdmin-on-Your-Windows-PC-Step-25.jpg/v4-460px-Install-phpMyAdmin- on-Your-Windows-PC-Step-25.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/15/Install-phpMyAdmin-on-Your-Windows-PC- Step-25.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-25.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}

Wait a few minutes for WAMP to finish installing.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/62/Install-phpMyAdmin-on-Your-Windows-PC-Step-26.jpg/v4-460px-Install-phpMyAdmin- on-Your-Windows-PC-Step-26.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/62/Install-phpMyAdmin-on-Your-Windows-PC- Step-26.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-26.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select a browser when prompted. Click Yes , browse for your commonly used browser EXE file, select and click Open .

For example, to select Chrome, you’d have to find and click the Google folder to the left of File Explorer, double-click the Chrome folder, and then select the Chrome icon.
If you just want to use Internet Explorer, click No.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b7/Install-phpMyAdmin-on-Your-Windows-PC-Step-27.jpg/v4-460px-Install-phpMyAdmin- on-Your-Windows-PC-Step-27.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b7/Install-phpMyAdmin-on-Your-Windows-PC- Step-27.jpg/v4-728px-Install-phpMyAdmin-on-Your-Windows-PC-Step-27.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight” :546,”licensing”:”<div class=”mw-parser-output”></div>”}

Choose another editor if necessary. If you don’t want to use Notepad as your server’s text editor, click Yes when prompted, then find the text editor EXE file you want to use, select it, and then click Open .

Click No if you want to keep Notepad as your default text editor.

Advice

If you’ve already set up a web server using a service other than Apache, you can install phpMyAdmin by copying the phpMyAdmin directory to the service’s root directory. This folder varies depending on the service you use.

Warning

phpMyAdmin is not set up to run directly on a computer that does not have another related server service (like Apache) installed.

Steps

Use the available Apache server

Use WAMP

Advice

Warning

Related Posts