your php installation appears to be missing the mysql which is required for wordpress

So you have PHP and MySQL installed now but your local copy of Wordpress just isn't wanting to play ball....

Well it turns out that you need to make a few changes to your php.ini file.

if you do a search for extension=php_mysql.dll and un comment it ie delete the ; at the beginning of the line

then search further up in the ini file for extension_dir="./" and replace ./ with c:\php\ext (assuming your php is in c:\php) so it will look like: extension_dir="c:\php\ext". This tells php that the dllfor the php_mysql.dll is located in c:\php\ext.

save your php.ini

Also copy libmysql.dll from c:\php c:\windows\system32 and then restart IIS.

you should now be able to use wordpress from your local PC.

Bookmark and Share

Comments

Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by Jon on 12/09/2008 16:31
Fantastic, someone who finally knows what they are doing. Thank you.
Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by cathal on 16/11/2008 11:38
HI, Im still getting Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
Is there anything else I should check?.. I have a number of PHP.ini files, which one is the one to be using?.
can I delete the others?. Thanks
Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by Tobias on 01/02/2009 13:11
Just wanted to let you know, you saved my day!

Thank you, sincerely!

/Tobias
Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by smack on 08/02/2009 01:19
I did all that and still get the message.
Im using Vista and IIS7...

Anymore help?
Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by Andrew Kemp on 08/02/2009 09:02
not really too sure what else it could be, it might be due to the fact that you have several ini files?

Other than that off the top of my head Iam not too sure what else could be causing that, as every time and ever machine I have had this issue on was caused due to this. same fix on Windows XP, Vista and Windows Server 2008. I have not yet tried on Windows 7 but I would guess it is the same as Windows Vista as Windows 7 uses IIS 7 still.
Gravatar # re: your php installation appears to be missing the mysql which is required for wordpress
Posted by John A on 01/04/2009 00:41
Just today i got this message from Firefox web browser: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. As soon as I hit the Firefox icon on my desktop.
My homepage happens to be www.englishrussia.com and I could not view the web page. All I did was run the free version of Adaware from www.lavasoft.com and if found 2 trojans and deleted them. Now my problem is gone. I hope this info helps somebody.
Gravatar # New Fashion Woman
Posted by NFW on 23/06/2009 13:30
Thanks for your idea, i'm already fix this erros!

Post Comment

Title *
Name *
Email
Url
Comment *  

Please add 8 and 7 and type the answer here: