MySQL version different from library

I'm getting new mail messages in Linux saying that "1 client is using or hasn't closed the table properly" for most of my tables in MySQL (including ISPconfig). I recently updated both Ubuntu to 9.10, and ISPconfig to the latest version.

I think that something may be wrong with my MySQL & PHP setup, when logging into phpmyadmin I get a warning on the bottom of the page that says:

"Your PHP MySQL library version 5.0.83 differs from your MySQL server version 5.1.37. This may cause unpredictable behavior."

How can I make it so that the library version and the server version are the same? And will this fix my errors in the mail that I'm receiving?

 

Do you use ISPConfig 2 or 3? If it's version 2, do you get the warning in ISPConfig's phpMyAdmin or in another phpMyAdmin?

 

I'm using ISPConfig 2, and I get it when I browse to www.mysite.com:81/phpmyadmin. I installed it through ISPConfig, however it says that error on the main page after you log into phpmyadmin.

 

Ok, I guess you need to rebuild ISPConfig. Just download the latest version (2.2.34) and install it.

 

It's odd that you say that, I just upgraded to 2.2.34 two days ago.

Could it of missed the MySQL part? Should I just try reinstalling?

 

Make sure that the newest version of libmysqlclient15-dev is installed...

Code:

aptitude install libmysqlclient15-dev

and then install 2.2.34 again.

 

Code:

apt-get install libmysqlclient15-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libmysqlclient15-dev is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

 

And you got the PHP MySQL library warning already before the upgrade, or only since then?

 

Hmm, to be honest it could of been there before.. but I never noticed it.

 

I'd try to install 2.2.34 again. I hope it solves the problem.

 

I'll give it a try and let you know. Thanks Falko.

 

Hmmm.. No luck, I tried reinstalling.