Testing WordPress Locally: Installing MySQL 2


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/adminstrator access.

Testing MySQL on Windows

  • Run the command prompt as Adminstrator
  • Navigate to the bin directory in the MySQLserver install directory
  • Type mysql -u root -p
  • At the prompt enter the password.
  • MySQL starts and you should see the mysql propmt
  • 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.

Leave a comment

Your email address will not be published. Required fields are marked *

2 thoughts on “Testing WordPress Locally: Installing MySQL