PHP MYSQL client doesnt match MySQL Server

PHP MYSQL client doesnt match MySQL Server

5 posts / 0 new
Last post
allan1015's picture
allan
Points: 0
PHP MYSQL client doesnt match MySQL Server

A new install of the Windows Damp stack, (all part of my getting familiar with Acquia the company - I ve several drupal servers going in this year)

When running phpmyadmin I notce this message:

Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.34. This may cause unpredictable behavior.

Just wondering if this needs to be updated, the PHP mysql library, and what a 'stack' wouldnt have worked out all the proper rev levels

I am having phpmyadmin issues with importing a mysqldump from my server, but I doubt this is that issue, just curious

Status: 
Duplicate
mhaag's picture
michael.haag
Points: 0

Allan, I confirmed the behavior you asked about. Interesting - I'd not noticed it before. I am following up with Engineering, and will get back to you soon.

regards, -m

Michael Haag
Tech Support, Customer Advocate, Quality Evangelist
Acquia

regards, -m

Michael Haag
Customer Advocate/Quality Evangelist
Tech Support

dmitry_bezer's picture
Dmitry Bezer
Points: 6

Hi,

Php 5.2.x (windows) comes with mysql client dll 5.0.51a, while we bundle Acquia Stack with mysql server 5.1.34.
Investigating this warning I experimented with client dll that comes with Mysql 5.1.34 and found that it is incompatible with PHP 5.2.x mysql extension.
The default client dll that comes with PHP seems to work fine with newer mysql versions so i think the warning can be safely ignored.

allan1015's picture
allan
Points: 0

OK, I understand the advice to ignore this, its a low risk
I guess what your saying is you cant find a PHP 5.2 client for MySQL 5.1?

So this is what fixed it, for me after a little google research

First an updated php_mysql.dll file from the Apache Lounge:
http://www.apachelounge.com/viewtopic.php?t=2992

Just replace the same file in the acquia_drupal/php/ext folder
(and if you need it pthe hp_mysqli.dll as well)

Second
Update the libmysql.dll file that is in the acquia-drupal/apache/bin folder

The problem is where to get the update, I had to install MySQL 5.1 on my PC and then lift the file from the bin/ folder in the mysql directory, then I uninstalled mySQL 5.1

Id attach it here but dont think this forum allows attachments/uploads.

Any after restarting the stack I no longer have warning messages in phpMyAdmin
adn I feel better :)

mhaag's picture
michael.haag
Points: 0

thanks for the update, Allan. Nice work. I'll fwd the info to Engineering, to see if they can incorporate it into the DAMP installer.

regards, -m

regards, -m

Michael Haag
Customer Advocate/Quality Evangelist
Tech Support