Page 1 of 1

PHP MySQL library version differs from MySQL server version

PostPosted: 10. May 2009 12:35
by mjwiech
Hi,

I installed the recent version of Xampp which is my absolute favourite local web server and I noticed the following:

1. MySQL server version is 5.1.33
2. MySQL Client API library version is 5.0.51b
3. MySQL Client API header version is 5.0.51a

Is it something I should worry about?
PhpMyAdmin version 3.1.4 gives me a warning that "This may cause unpredictable behavior". PhpMyAdmin 3.1.3.1 says nothing in that matter.

Is it possible to fix somehow?
Does PHP support MySql 5.1.33?
I think that the libraries involved are libmysql.dll and PHP extensions php_mysql.dll and php_mysqli.dll.

I noticed also that there are more than one copy of libmysql.dll:
- in \Xampp\apache\bin
- in \Xampp\mysql\bin (this is the newest one)
- in \Xampp\php\bin
Which one is relevant during Xampp run time?

Kind regards
mjw

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 11. May 2009 05:55
by mjwiech
No tips?

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 12. May 2009 15:44
by argh6601
I too am looking for a fix for this

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 20. May 2009 14:28
by mjwiech
argh6601 wrote:I too am looking for a fix for this


Thanks a lot!

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 21. May 2009 12:03
by sari42
- in \Xampp\mysql\bin (this is the newest one)

try the following:
rename all other libmysql.dll to, e.g., old-libmysql.dll
copy \Xampp\mysql\bin\libmysql.dll into your %windir%\systems32\ directory
(or into the first folder in your search path)

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 28. June 2009 14:27
by RKramkowski
So did this work? I tried copying the dll to all the other locations you listed. When I bring up mySqlAdmin, it now shows that the client and server match, but it doesn't run. For now, I reverted back to the older client.

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 28. June 2009 18:52
by rdwonline
I'm hoping this will be fixed when the developers add PHP 5.3 final to XAMPP...

Re: PHP MySQL library version differs from MySQL server version

PostPosted: 03. July 2009 13:14
by mjwiech
As yet Xampp works ok with this version difference.
I've seen something about a bug... but I don't recall whether it was a bug in MySQL library, in PhpAdmin or somewhere else.