I am setting up my first dedicated box.
- Windows 2003,
- IIS6,
- PHP 5.2 build 3790
- MySQL5.
I had my host install PHP for me.
I installed MySQL and got it working fine with my Coldfusion pages – so we know the database is work.
I created a PHP hello world page and it worked fine. So we know PHP is working.
But when I tried my WordPress blog I get:
“Your PHP installation appears to be missing the MySQL which is required for WordPress.”
So I Google the error and found this helpful page:
http://wordpress.org/support/topic/105098
I added both IUSR_COMPUTERNAME and “Network Service” to have
read/write access to C:\PHP like they talked about – but that didn’t work.
I made sure that the php_mysql.dll extension was uncommented (restarted IIS) – but that didn’t work.
In php.ini file, I changed the “extension_dir” to point to “./ext/” (restarted IIS) – but that didn’t work.
I then tried “extension_dir” to point to “C:\PHP\ext\” (restarted IIS) – but that didn’t work.
I then tried “extension_dir” to point to “C:\PHP\” (restarted IIS) – but that didn’t work.
Here is the php info for MySQL:
Update: I figured it out. All the settings above are correct. For some reason I just needed to reinstall Wordpress.
Update 2: I didn’t have to reinstall WP, all I had to do was deactivate one of my plugins (Quick Stats which was causing the error).
Related Articles
8 users responded in this post
I almost couldn’t understand what you have wrote.
Sorry, it was just mostly documentation for me if it happened again. But I thought if I could help others I would publish it too.
I hope it helped a little.
hey Dave,
how did you get the php info off your system?.. this error is breaking my heart….have tried everything. I seem to have three php.ini files. which one is the definite one to use? can i delete the others?.. thanks i advance, C
Cathal,
I created a blank php page on my server with the following and then viewed it:
< ?php echo "Hello, World!!!"; ?>
< ?php
// Show all information, defaults to INFO_ALL
phpinfo();
// Show just the module information.
// phpinfo(8) yields identical results.
//phpinfo(INFO_MODULES);
?>
Hi Dave,
I have pretty much the same set up you have. I’m running CF8, MySQL 5 and IIS 6. All my sites are working fine and MySQL is tickerty boo.
PHP is working http://caspianit.co.uk/hello1.php which is the code you’re using above to get stats from PHP.
I have WordPress working fine under Apache, but I didn’t like the way I needed to add every site I had to a httpd.config file and although WP was working fine I decided to go back to IIS 6.
But having just installed FastCGI, PHP 5.2.8 and configured IIS to accept the .php extension I’m now getting that wonderful: Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
I tried to follow numerous solutions but nothing, nothing, nothing does the trick.
I’m hoping to find some intelligent advice that doesn’t involve me battering my head with mustard or standing in a goldfish bowl.
Could you offer any help?
Many thanks
But when I try WordPress I get the dreaded
Thank you so much. I have solved my problem. Thank you again for this useful article…
Thanks for the notes. I had to also put libmysql.dll into the windows\system32 folder.
This should resolve the issue..
http://alltips.in/how-to-fix-your-php-installation-appears-to-be-missing-the-mysql-extension-which-is-required-by-wordpress/
Leave A Reply