WordPress › Support » Your PHP installation appears to be missing the MySQL which is required for WP

michaelhcox
Member
Posted 1 year ago #

I'm running WinServer 2003 with IIS 6. I've never used PHP or WordPress before. I'm trying to get it all installed and working. I've downloaded MySQL and PHP 5. I've created teh Database, username & password. I've modified the wp-config.php file. Now, I'm trying to go to the /wp-admin/install.php and I keep getting a message that says:

"Your PHP installation appears to be missing the MySQL which is required for WordPress."

I've triple checked everything. I've looked online and tried various things. Nothing yet. Any suggestions?
Otto42
Moderator
Posted 1 year ago #

You need to edit your PHP installation to load the mysql library. Look at your PHP.INI file. Search for "mysql" in it. It may be as simple as uncommenting the line that reads:
extension=php_mysql.dll
Or it may be more complicated than that. Hard to say without looking at your installation.
michaelhcox
Member
Posted 1 year ago #

Tried that with no difference. Someone else told me to remove if ( !extension_loaded('mysql') && !file_exists(ABSPATH . 'wp-content/db.php') )
die( 'Your PHP installation appears to be missing the MySQL which is required for WordPress.' ); from my wp-settings.php file. Now I get a blank page. Any other suggestions?
michaelhcox
Member
Posted 1 year ago #

If it helps, when I run php-win against install.php at a Command Prompt, it appears to work. It just doesn't in IE or FireFox.
michaelhcox
Member
Posted 1 year ago #

I figured it out. I had forgotten to give my IUSR user access to the c:\php directory. Silly me! :)
aawaltz
Member
Posted 1 year ago #

Folks,

I had the same problem with the same err msg.

Here's how I solved it.
- Looked at Apache error.log. It pointed to php_mysql.dll not being loaded

- In php.ini file, fixed the "extension_dir" to point to "./ext/" (since I'm using PHP5)

- Restarted Apache.

Hope this helps somebody.

ENV: Apache 2.2.4; PHP 5; Wordpress 2.1
BrianM
Member
Posted 1 year ago #

Hello,

I couldn't get it to work with IIS 5.1 on XP Pro SP2, so I installed Apache and that worked. (I didn't use any of the user tips on this site) I picked up a book on PHP & MySQL and followed it's installation instructions for Apache, PHP and MySQL. I bought the 2007 edition. It's sad that many technical books on the shelf are obsolete. The first one I tried was two years old and was a waste of time.

Environ: Apache 2.2.4; PHP 5.2.0: MySQL 5.0; Wordpress 2.1
vkaryl
Member
Posted 1 year ago #

Yup, that works. But the best way every time is xampp from http://www.apachefriends.org/en/xampp.html - they've already done all the hard work....

There are similar versions for linux and mac.
stimpy77
Member
Posted 5 months ago #

Ran into the same problem. Using IIS 6 with PHP 5 and FastCGI. PHP is installed at C:\PHP manually using threading-unsafe manual deployment (see www.iis.com/php)

Made sure to add IUSR_COMPUTERNAME and "Network Service" to have read/execute access to C:\PHP. (This was already configured at the wordpress directory location.)

Modified php.ini so that instead of './' as the extensions directory it was 'C:\PHP\ext\'. I had changed it to 'C:\PHP\' but apparently that was incorrect.

Also removed the comment (semi-colon) behind the mysql DLL,

.. from ..

;extension=php_mysql.dll

.. to ..

extension=php_mysql.dll

Start menu, Run..., "iisreset"

Works.
cebrooks
Member
Posted 5 months ago #

Still having issues with this. Mysql does not reside on the same server but that should not matter. I have my cfg file pointing to the proper ip, correct? I'm rreally stumped on this one. I have spent countless hours configuring and reconfiguring things. Tripple checking setting and I still get the dreaded "Your PHP installation appears to be missing the MySQL which is required for WP" page. Any ideas on what I could be missing?
cblair
Member
Posted 4 months ago #

I have found multiple sites with the above solutions, plus gobs more about copying .dll's and .ini's back and forth from the php/ext dir, mysql/bin dir, and winnt/dir. Still no go. Apache error.log says nothing is wrong, and I am able to do all of my other PHP and MySQL fine on my local server. Queries all work, etc. The only thing that doesn't work is WP. So maybe someone sees a problem with my test.php output:

msql
MSQL Support enabled
Allow Persistent Links yes
Persistent Links 0/unlimited
Total Links 0/unlimited

mysqli
MysqlI Support enabled
Client API version 4.1.7
MYSQLI_SOCKET /tmp/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
tbradt
Member
Posted 4 months ago #

after a full day of searching i found the solution to this problem....at least for me. It seems all I had to do was add ISS_IUSRS as a user on the php.exe. Did that and everything works great now. Just thought I'd share