How to setup WordPress locally: Installing phpMyAdmin

Published on

Last Updated on

Estimated Reading Time: 1 min

Installing phpMyAdmin on Windows

  • Go to the phpMyAdmin Website and download the zip file
  • Unpack the downloaded file to the web server Document root.
  • Optional: Rename the directory.
  • Create a copy of the file config.sample.inc.php and rename it to config.inc.php
  • Open config.inc.php for editing and add/update the following
    • $cfg['Server'][$i]['user'] = 'root';
    • $cfg['Server'][$i]['password'] = 'root-password'

Configuring the web server for phpMyAdmin

  • Open the httpd.conf file(located in the conf folder of the webserver) for editing
  • Find DirectoryIndex and add index.php. This will look something like this
    • DirectoryIndex index.html index.php

Configuring php for phpMyAdmin

  • Open php.ini (in the System Directory) for editing
  • Remove the semicolon from the line ;extension=php_mbstring.dll
    • If the line does not exist, add the line.

Testing phpMyAdmin

  • Restart the server
  • Navigate to http://localhost:8080/phpMyAdmin/ on the browser.
  • You should see the phpMyAdmin login window
  • Enter the username and password in the login window.
  • You should now see the phpMyAdmin Control panel