www.flickr.com
Michael Kovacs' photos More of Michael Kovacs' photos
Recommend Me Cable Car Software logo

Thursday, March 29, 2007

Installing Wordpress with MySQL 4.1 and higher

Some 5 minute install that was. Just finished installing Wordpress for our site's blog and it would've been easier if I didn't have to build and install PHP though that wasn't hard. The harder part was the lack of information that came out of wordpress when the install script didn't work.

Turns out that the password for the user I created in MySQL needed to be hashed in the "old" way for PHP 4.

The way I figured out the problem was I created a PHP file in the root of my wordpress install that contained the following:

$username = "blog";
$password = "passowrd";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL
";
// you're going to do lots more here soon
mysql_close($dbh);
?>


Running that page gave me:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

OK so now we're getting somewhere. Googling that error eventually led me here:
http://www.digitalpeer.com/id/mysql

going to modify my blog user in the manner prescribed in that posting fixed me right up and my wordpress installation was done. So minus that hangup it really would've been a 5 minute install.

Anyhow, I know most folks reading here are probably using something like mephisto which I considered as well but I decided to go with wordpress for various reasons, one of which was that PHP is going to run a bit faster and take up less memory than a mongrel running rails. Then again nginx would take up much less than Apache but that's a battle for another day.

This page is powered by Blogger. Isn't yours?