Testing Wordpress Locally: Installing MySQL

This entry was posted on
  • Tutorial
  • Wordpress

The Series

  1. Installing a Web Server (Apache)

  2. Installing PHP

  3. Installing MySQL

  4. Installing phpMyAdmin

  5. Installing Wordpress

Installing MySQL on Windows

  • Go to the MySQL Website and download the installer file from the windows section.

  • Run the installer.

  • Choose the Developer Default and click on Execute.

  • On the MySQL Server Configuration Dialog, enter the password for the root/administrator access.

Testing MySQL on Windows

  • Run the command prompt as Adminstrator.

  • Navigate to the bin directory in the MySQL server install directory.

  • Type mysql -u root -p.

  • At the prompt enter the password.

  • MySQL starts and you should see the MySQL prompt.

  • Type quit to exit.

Activating MySQL for PHP

  • Open the php.ini file for editing
  • Remove the semicolon from the line ;extension_dir =“ext”

    • If the line does not exist, add the line.
  • Change ext to point to the ext folder in the PHP install directory.

  • Remove the semicolon from the line ;extension=php_mysqli.dll

    • If the line does not exist, add the line.
  • Restart the APACHE server.