Install phpMyAdmin on Your Windows PC

phpMyAdmin allows you to control your MySQL server from a web browser. Installing phpMyAdmin is a quick process that will have you up and running in a few minutes. Once installed, you can create databases, tables, MySQL users, as well as set privileges for MySQL users for particular tables or databases.

Steps

Using Web Server Software Packages

  1. Download WampServer. You will need to install a local web server on your Windows computer in order to install phpMyAdmin. WampServer is one of the easiest ways to get things up and running, and automatically install phpMyAdmin for you. There are a variety of other software bundles available as well, such as XAMPP.
    • You can download WampServer for free from wampserver.com.
    • Make sure to download the correct version for your version of Windows. To determine if you are running a 32-bit or 64-bit installation, click here.
  2. Run the setup program and follow the prompts. Most users can leave everything at the default settings, though you can change the installation location if you want to install WampServer on a different drive.
  3. Select your default browser. WampServer will ask you to select the browser you want it to run in. By default, it will have Internet Explorer selected, though you can select from any of your installed browsers. Below are some typical default installation locations for browsers:
    • Firefox - C:\Program Files\Mozilla Firefox\firefox.exe or C:\Program Files (x86)\Mozilla Firefox\firefox.exe
    • Chrome - C:\Program Files\Google\Chrome\Application\chrome.exe or C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
  4. Allow WampServer to access your firewall. Windows will prompt you to allows WampServer to access your firewall. Click the Allow access button to allow it.
  5. Enter your email settings. Leave the "SMTP" field empty and enter your email address into the "Email" field.
  6. Click the WampServer icon in your system tray. This is located in the bottom-right corner of your desktop.
    • If the icon is green, WampServer is online. If the icon is a different color, you may need to try installing WampServer again.
    • Note: WampServer will not start if Skype is running.
  7. Select "phpMyAdmin". This will open the phpMyAdmin configuration page in your web browser.
  8. Start using phpMyAdmin. You can now use phpMyAdmin to create new databases and manage users. Create-a-Database-in-phpMyAdmin.

Installing phpMyAdmin on Any Web Server

  1. Download the phpMyAdmin setup files. You can get them for free from phpmyadmin.net. Click the Download button at the top of the page to get the latest version. This method assumes that you have already setup a local web server with MySQL.
    • Install-the-Apache-Web-Server-on-a-Windows-PC.
    • Install-the-MySQL-Database-Server-on-Your-Windows-PC.
    • Install-PHP-5-for-IIS-6.
  2. Extract the downloaded files. Double-click the downloaded ZIP file to extract the folder.
  3. Copy the extracted folder to your local web server's document root. Depending on how you configured your web server, this could be the www, htdocs, html, or public_html folder.
    • If you are using IIS, open IIS Manager. In the left navigation tree, right-click on "Default Web Site" and select "Explore". Copy and paste the extracted phpMyAdmin folder into the location that opens.
  4. Rename the folder to .phpMyAdmin. The folder you copy will likely have a long name denoting the languages contained. Simplifying the name will make it easy to reference.
  5. Open your browser and type .localhost/phpMyAdmin/. If you see the login page for the phpMyAdmin dashboard, you can move on to the next step. If you see a list of the contents of your phpMyAdmin folder, see the Troubleshooting section at the bottom of this method.
  6. Enter .root as the user name.
  7. Enter your MySQL password in the password field.
  8. Start using phpMyAdmin. You can now use phpMyAdmin to create new databases and manage users. Create-a-Database-in-phpMyAdmin.

Troubleshooting

  1. Open the .apache folder on your computer. This will typically be located at bottom level of your hard drive.
  2. Open the .conf folder.
  3. Open the .httpd.conf file.
  4. Press .Ctrl+F and search for index.html.
  5. Change .index.html to index.php. Save the file and close Notepad.
  6. Press .⊞ Win+R and type services.msc. This will open the Services window.
  7. Find the "Apache" entry and click the Restart button.
  8. Reload the .localhost/phpMyAdmin/ site in your browser. You should see the login page for phpMyAdmin.

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Install_phpMyAdmin_on_Your_Windows_PC&oldid=274405"