How to Install phpMyAdmin on Your Windows PC

PDF download Download Article
Get phpMyAdmin up and running on Windows quickly
PDF download Download Article

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

Quick Steps

  1. Download phpMyAdmin from the main phpMyAdmin site.
  2. Copy your phpMyAdmin folder and paste it into the Apache host folder.
  3. Rename the folder to phpmyadmin and open the PHP folder inside.
  4. Rename the php.ini-production file to php.ini and open it with Notepad.
  5. Remove the " ; " from the extension=php_mbstring.dll line of text.
  6. Remove the " ; " from the extension=php_mysqli.dll line of text.
  7. Save your changes, run the Apache program, and test the program on a web browser with http://localhost .
Method 1
Method 1 of 2:

Using an Existing Apache Server

PDF download Download Article
  1. Apache , PHP, and MySQL must all be installed and configured on your computer before you can install phpMyAdmin in this way.
  2. Go to https://www.phpmyadmin.net/ in your browser. [1]
    Advertisement
  3. It's a green button in the upper-right side of the page. The phpMyAdmin ZIP folder will begin downloading onto your computer.
    • You'll also see the version number next to Download (e.g., for the June 2023 version of phpMyAdmin, you'd click Download 5.2.1 ).
  4. This will return you to the phpMyAdmin webpage.
  5. Double-click the downloaded phpMyAdmin ZIP folder to do so.
  6. Click the regular phpMyAdmin folder in the ZIP folder's window, then press Ctrl + C .
  7. This is typically a folder named "htdocs" inside of the "Apache" folder, which should be located in the "C:" folder on your hard drive.
    • The Apache host folder usually has a text document named "index.php" or something similar.
    • The fastest way to get to this folder is by clicking This PC on the left side of the window, double-clicking the Apache folder, and double-clicking the htdocs (or similar) folder.
  8. Press Ctrl + V to paste the copied phpMyAdmin folder into the Apache host folder.
  9. Click the phpMyAdmin folder, click Home , click Rename in the toolbar, type phpmyadmin into the folder's name field, and press ↵ Enter .
  10. This folder is located in the "C:" folder along with the "Apache" folder. Once you find the PHP folder, double-click it to open it.
  11. You'll change this file's name to php.ini . [2]
  12. It will open in your default text editor (e.g., Notepad), though you may first have to select Notepad from a list and click OK .
  13. You'll see the semicolon to the left of this line of text.
    • You can press Ctrl + F to bring up a "Find" window where you can enter this line of text to go to it.
  14. Once you've done this, your phpMyAdmin server is good to go.
  15. Press Ctrl + S to save, then click the X in the top-right corner of the Notepad window to exit Notepad.
  16. Open Command Prompt in Administrator mode by right-clicking Start
    Windows Start
    , clicking Command Prompt (Admin) , and clicking Yes when prompted, then do the following: [3]
    • Type in cd /Apache24/bin and press ↵ Enter (replace "Apache24" with your Apache folder's name).
    • Type in httpd -k restart and press ↵ Enter .
  17. Open a web browser, then type http://localhost into the address bar and press ↵ Enter . This should take you to the phpMyAdmin login page.
    18. Advertisement
Method 2
Method 2 of 2:

Using WAMP

PDF download Download Article
  1. WAMP allows you to interact with an existing server on your computer, but won't create a server in and of itself.
  2. Check your computer's bit number . You'll need to know this in order to determine the version of WAMP that you can download.
  3. Go to https://www.wampserver.com/en/ in your web browser.
  4. The number that you choose here will depend on your computer's bit number. Clicking either option will prompt a pop-up window.
  5. It's in the upper-right side of the pop-up window. Doing so takes you to a Source Forge page from which you can download your version of WAMP.
  6. This green button is near the top of the page. WAMP will begin downloading onto your computer.
    • The download will take several minutes to complete.
  7. Double-click the downloaded WAMP setup file, then do the following:
    • Click Yes when prompted.
    • Select a language and click OK
    • Check "I accept the agreement" and click Next
    • Click Next three times.
    • Click Install
  8. This will take a few minutes.
  9. Click Yes , then go to your preferred browser's EXE file, click it, and click Open . [4]
    • For example: to select Chrome, you would find and click on the Google folder on the left side of File Explorer, then double-click the Chrome folder and select the Chrome icon.
    • If you would prefer just to use Internet Explorer, click No instead.
  10. If you don't want to use Notepad as your server's text editor, click Yes when prompted, then find the EXE file for the text editor that you want to use, select it, and click Open .
    • Click No if you want to keep Notepad as the default text editor.
  11. Click Next , then click Finish on the final WAMP window. WAMP is now installed on your computer.
  12. Double-click the pink "Wampserver" icon on your desktop, then click Yes when prompted. This will prompt your server to start running.
  13. On the far-right side of the Windows toolbar, you should see an orange or green WAMP icon. Clicking this will prompt a pop-up menu.
    • You may first have to click the upward-facing arrow in the toolbar to see the WAMP icon.
  14. It should be near the top of the pop-up menu. As long as your server is properly installed, doing so will open the phpMyAdmin login page in your preferred browser.
    15. Advertisement

Community Q&A

Search
Add New Question
  • Question
    What do I do if I type localhost/phpmyadmin/, and it says "localhost refused to connect"?
    Community Answer
    There is error in the database connection. Try to solve that first. Check your connection code and try again. Also check whether the localhost ID is correct.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 2 Helpful 12
  • Question
    How can I install and use this?
    Community Answer
    Go to the phpMyAdmin website and download it from there. You will need a server.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 20 Helpful 9
  • Question
    How can I launch the WAMP?
    Rajsolanki15april
    Community Answer
    To launch WAMPServer, double-click its desktop or Start Menu icon. Look for its icon in the system tray; when it turns green, the server is ready. Access your server by typing "localhost" in your browser's address bar. Manage settings and projects through the WAMPServer menu in the system tray, where you can start or stop services and access phpMyAdmin for database management.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 0
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • If you've set up a web server using a service other than Apache, you might be able to install phpMyAdmin by copying the phpMyAdmin folder into the service's root folder. The folder used will vary widely from service to service.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • phpMyAdmin is not set to run directly on a computer that doesn't have other server-related services (e.g., Apache) installed.
        Thanks
        Helpful 1 Not Helpful 0
      Advertisement

      You Might Also Like

      How to
      Install WAMP
      How to
      Install the Apache Web Server on a Windows PC
      How to
      Login to a Website as an Admin
      How to
      Take a Screenshot on a Windows PC: 8 Simple Tricks
      How to
      Check Your Windows Version
      How to
      Find Your Windows Product Key
      Easily Download and Install FFmpeg on a Windows PC
      How to
      Check Your Mouse DPI on Windows & Mac
      How to
      Start Windows in Safe Mode: 6 Easy Options
      5 Quick Ways to Change Your Desktop Wallpaper on Windows
      4 Easy Ways to Access the Boot Options Menu in Windows
      How to
      Access the BIOS on Any PC: Guide + Troubleshooting
      How to
      Disable BitLocker Encryption in Windows 10 and 11
      3 Easy Ways to Move a Full Screen Game to Another Monitor
      Advertisement

      References

      1. ↑ https://www.phpmyadmin.net/downloads/
      2. ↑ https://www.youtube.com/watch?v=dfly7eNym4Y
      3. ↑ https://www.w3resource.com/php/installation/install-wamp.php
      4. ↑ https://www.w3resource.com/php/installation/install-wamp.php

      About This Article

      Article Summary X

      1. Install Apache, PHP, and MySQL.
      2. Download phpMyAdmin from https://www.phpmyadmin.net .
      3. Unzip the file.
      4. Copy the folder.
      5. Paste the folder into your htdocs folder.
      6. Rename the folder "phpmyadmin."
      7. Rename "php.ini-production" to "php.ini" and open it.
      8. Remove the semicolon to the left of "extension=php_mbstring.dll" and save.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,217,819 times.

      Is this article up to date?

      Advertisement