Your PHP installation appears to be missing the MySQL extension which is required by WordPress

by Cliff 8. January 2009

I was recently setting up WordPress to run locally on my development machine and when I tried to browse to the WordPress homepage locally, I recieved the error:

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

My configuration:
Windowx XP
Apache 2.2
php-5.2.8
MySQL 5.1

To correct this issue, I did the following:

  1. In the Php.ini file (on my machine this is located at C:\Windows):
    Set extension_dir = "C:/Program Files/php-5.2.8/ext" (where php is installed on my machine)
  2. uncommented (remove ;)
    extension=php_mysql.dll
    extension=php_mysqli.dll
  3. Copied libmysql.dll from php dir to system32 (C:\WINDOWS\system32 on my machine)

Hope that helps anyone with a similar issue.

Related posts

Comments

January 16. 2009 17:06

Gravatar

Thank you so much for this post. Step 3 is what did it for me. I have spent about 3 hours messing with this problem today. It all broke after I installed Plesk on my server. I had problem after problem after removing it! I was finally able to get my blog back after copying the right dll file.

Thanks a million!!!!

Juan Quintana us

February 27. 2009 04:11

Gravatar

thanks for telling all this..the steps are useful..

Short Jokes in

May 14. 2009 04:50

Gravatar

I cannot thank you enough for this. I have used the "Microsoft Web Platform" installer yesterday to install some scripts and some of them required fastCGI so I installed it too, but that screwed up my current php's installation and today, when I tried to continue my work on a wp theme that error was thrown...and I searched for different solutions but couldn't find one; I've reinstalled php, uninstalled the "Microsoft Web Platform" and the FastCGI application but still couldn't fix this.

The step #3 was all I needed. (No need for the steps #1 or #2 for me).

Thanks a bunch, you saved my day :)

Costin Trifan ro

August 23. 2009 11:47

pingback

Pingback from blog.sban.com.cn

sban blog : Your PHP installation appears to be missing the MySQL extension which is required by WordPress

blog.sban.com.cn

August 27. 2009 01:35

Gravatar

You are the best! Thanks so much for sharing your solution!

Michael ca

September 1. 2009 03:29

Gravatar

Thks a lot for your post.

brian

September 27. 2009 20:16

Gravatar

Thanks mate!I was looking for that solution nearly all day!I love your blog,awesome!!!
Can I copy this article on my blog?If,yes we can exchange useful articles in the future?

Интернет Маркетинг

October 31. 2009 11:40

pingback

Pingback from inftex.net

Ein Semikolon macht mir das Leben schwer… - inftex.net

inftex.net

March 3. 2010 07:45

Gravatar

Nice post! I really didn't know why PHP & MYSQL installation was acting strange until I actually read this post.

RegCure Review gb

March 10. 2010 01:53

Gravatar

Hi;
I have the same problem.
I use windows 2008 server and iis7. I installed php and my sql Both are working fine separetly. But php missing my sql extensions. So no way to communicate with my sql db.

I made changes as you mentioned. But im still stugeling with this

Please help

amila us

August 7. 2010 12:56

pingback

Pingback from junweihuang.info

Open Junweblog on Via Train | junweblog

junweihuang.info

September 6. 2010 22:35

Gravatar

Thanks a million, #3 did the trick.

STFUDonny

July 22. 2011 12:57

pingback

Pingback from keiko.tw

在Windows Server 2008 x64 IIS7上使用PHP | 水瓶雙魚

keiko.tw

Comments are closed

Cliff Gray's Info

Cliff Gray
Developer/Founder GrayTechnology.com.

E-mail me Send mail

Authors

Calendar

<<  April 2018  >>
MoTuWeThFrSaSu
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456

View posts in large calendar

Blogroll

Download BlogEngine.NET

Download at CodePlex

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2018

Subscribe