Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.34

dmacman1962

Hi All,

I believe this would be the correct forum for this question.

I just finished installing PHP (5.2.9-2), MySQL (5.0.51a) and Apache (2.2.11) on our new server (Windows 2003 Server) and I am working thru all the configs, and in phpMyAdmin, I am getting this error.

Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.34

I have read about 50 posts regarding this and not one has helped me solve it.

Some stated that it is nothing to be concerned about, but since this will host our site, I do not want anything I can resolve now, to come back to 'hinder me' later.

phpMyAdmin page:
Server version: 5.1.34-community

* Apache/2.2.11 (Win32) PHP/5.2.9-2
* MySQL client version: 5.0.51a
* PHP extension: mysql

phpinfo page:

mysql
Client API version 5.0.51a

mysqli
Client API version 5.0.51a
Client API header version 5.0.51a

I have tried to copy the libmySQL.dll from the MySQL Server 5.1/bin directory to the PHP directory, the windows directory and the System32, and nothing worked. Either I get the same error, or a communication problem when I go to the phpMyAdmin page.

Does anyone have any fixes for this?

Thanks in advance,
Don

juliaum

Dude, I'm exactly the same problem as you, until the versions of MySQL are the same, I wonder if you managed to find a solution on this.

Thanks

Altairzq

Hi, I have the same problem too, with same versions you both are mentioning.

Not only that, two hosting sites I tried also have different versions for the Mysql server and the client. Both have:

* Server version: 5.0.67-community

* MySQL client version: 4.1.22

(but phpMyAdmin doesn't show any warning... maybe deactivated? or these two versions are compatible?)

Can't find any clear information either about this issue through Google.

juliaum

And this is really complicated to resolve well, I found a forum of Zend, many people with this same problem and they said they would need to recompile the MySQL library php, so it would not be very advisable, so that I did it was a downgrade of the MySQL Server for the same that the library of PHP MySQL.

This was the way I found to avoid this error, do not got to read the MySQL documentation about what happened to change / implementation in the new version. But as I am not doing a very big project just to make the downgrade.

And that staff there, well I am here in Brazil, so my English is not 100%, you may find some errors there ...

😃😃

VLW ...🙂

Faloww