PHP MYSQL library differences


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

This may have been asked many times, but I haven’t been able to query it. This has to do with Phpmyadmin.

Does anyone have any idea if this is good or bad?

Unpredictable behaviour doesn’t sound good to me.

If possible, update your PHP installation to the latest available version. If you’re using a shared hosting that provides both PHP and mySQL services, you must ask them to update PHP (and/or mySQL libraries used by PHP). They should have no objection updating it as this is probably a mistake on their part.

I’ve gotten that warning message for years and never once have I had any problems with it. I wouldn’t worry about it if I were you.

Cheesedude’s experience will not guarantee you won’t have problems. You should definitely update your php version. Different apps could have different effects of version disparity based on what features they’re using. Eg cheese may just be using simple crud. You may use sprocs and they may break. Can’t be certain. Better safe than sorry.

Good luck finding the appropriate PHP MySQL library. Just because MySQL changes versions, that does not automatically mean that PHP keeps pace.

You don’t have to update the entire PHP install, just libmysql. Check documentation here: MySQL :: MySQL 5.5 Reference Manual :: 20.10.2.3 Installing/Configuring

If you’re using Ubuntu, this should upgrade you to latest drivers:

> apt-get update
> apt-get install php5-mysql
> apt-get install php5-mysqli

Not sure how to use other package installers (I’m an Ubuntu guy).