mySQL and local installation

Good for you, for developing locally rather than on a live production server.

You also need PhpMyAdmin, which I trust you also downloaded? You can use that tool to create a new database. It serves as the graphical user interface to interact with your mysql database.

I trust you installed mysql in the same directory as apache? And be sure mysql is running, which, of course, requires admin credentials.

It’s easier to do all of this local set-up by just auto-installing the software package, XAMPP (which is a WAMP server).

But an even easier way to set up dev sites on local machine is to use Serverpress’ Desktop Server, which is a great little script that enables you to not only click and install dev sites on the fly, after it handles the install and configuration of a local apache server, but also modifies paths with one click while doing a click/upload to your live server. I do a lot of building and this script enables me to create loads of dev sites without the fuss you are engaging in. (No affiliation with ServerPress/just happy customer.) Just Google it..

On the other hand, I also have a linode slice where I’ve been mastering setting up of ningx engine, ubuntu and a multi-platform drupal. If you want to really get into server setup, it’s a great place to have as a sandbox. But if you want to get to building a site fast, then I encourage you to take a look at Desktop Server.

Solution 1:

Check your php.ini and make sure that you have extension=php_mysql.dll un-commented.

Solution 2:

You can use the following library if you do not have mysql_connect enabled but have PDO enabled:

https://github.com/AzizSaleh/mysql

Create a new file: wp-content/db.php and place this code in it (update your path to mysql with path to your extracted folder):

<?php
$pathToMySQL = 'C:\\xampp\\htdocs\\mysql\\';
require_once($pathToMySQL . 'MySQL_Definitions.php');
require_once($pathToMySQL . 'MySQL.php');
require_once($pathToMySQL . 'MySQL_Functions.php');