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

August 28th, 2009 · No Comments · Technical

If you have an Apache, PHP, MySQL setup on a Windows 2003 machine then this could possibly help you resolve the error message:

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

The fix for myself is really simple. I assume all is working fine, the only problem you are having is your MySQL connection to WordPress, but Apache and PHP are working perfectly fine. I also assume all MySQL prerequisites have been done, such as uncommenting php_mysql.dll and php_mysqli.dll in the php.ini file and the libmysql.dll file has been placed in the System32 folder. And all the proper permissions exist on all files.

The first thing you should do is create a phpinfo() file. Open notepad and enter the following

<?
php phpinfo()
?>

Save the file as phpinfo.php and upload to your web server. Then browse to the file from a browser, i.e. http://www.YOURWEBSITE.com/phpinfo.php

In the phpinfo.php check the file row for “Loaded Configuration File” (about 7 rows down), take note of the file location. It should say (none). Go one step further and do a search on the page for “mysql”. Didn’t find any? Then continue.

To fix the problem, simply take the php.ini from C:\Windows and put it in your PHP root path, i.e. C:\PHP

Restart Apache and try again!

If you just wanted to change the way Apache finds your php.ini file then in your Apache httpd.conf file find lines similar to this,

#PHP Configuration
PHPIniDir “C:/php”

Change it to your preferred location such as “C:/Windows”

You get it!

Tags: ··

No Comments so far ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment