Mysql server update cause error in php myadmin.

Hi E's

I have updated my mysql server from 5.0 to 5.1.x.

before it works fine, but after upgrading its displaying error in my phpmyadmin.
Error is as below:
"Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.45. This may cause unpredictable behavior."

I am not getting what to do with this.

Hope i am clear to all.

Thanks in advance
Addy
LVL 12
Avinash ZalaWeb ExpertAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

theremonCommented:
Hi there

if I remember correctly, you need to enable the mysql native driver for this to work 100% fine.
This should help:
http://dev.mysql.com/downloads/connector/php-mysqlnd/

However, if you use PMA for more-or-less the standard tasks, don't expect to see anything crazy.
0
theremonCommented:
Also, make sure you set up PMA to use the mysql driver - not mysqli. That makes quite a difference as far as the client api version is concerned.
0
theremonCommented:
One more question - which PHP version are you using? Versions prior to 5.3 had mysql client libraries that did not officially "support" MySQL >5.1
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Avinash ZalaWeb ExpertAuthor Commented:
Here is my configuration:

PHP Version 5.2.9-1

Apache/2.0.59 (Win32) PHP/5.2.9-1

MySQL client version: 5.0.51a

Server version: 5.1.45-community

PHP extension: mysql

Can you please suggest what to do in my case.

Addy
0
theremonCommented:
Hmmm... first of all - any chance you can upgrade PHP to 5.3+?
I remember having this issue with versions prior to 5.3 (like 5.2.8 or 5.2.9).
If not, I'll try to set up a vm with your config and see how this can be fixed.
Are you by any chance using XAMPP or WAMP?
0
Avinash ZalaWeb ExpertAuthor Commented:
no
0
Avinash ZalaWeb ExpertAuthor Commented:
I have configured php mysql separately.
0
theremonCommented:
Hi again Addy

unless you upgrade your PHP version, you're out of luck. I did some research and everybody is talking about the same solutions:
1. Upgrade PHP - the 5.2.x client is simply not as new as it should for the latest versions of MySQL.
2. Compile your own MySQL DLLs for PHP. Let's not even get into that - if it's difficult to upgrade PHP, you don't want to mess with compiling DLLs
3. Simply disable the error in PMA (no real effect other than you just don't see it anymore)

Other than that, my own findings and thoughts:
1. I remembered that I had a laptop that was showing this error. I had installed PHP via the Microsoft Web Platform installer on that laptop and MySQL manually. That very laptop was used to test several aspects of PHP development on Windows and was intentionally left with a previous version of PHP. FYI, the installation was: PHP 5.2.11 (MySQL client 5.0.51a) and MySQL 5.1.41. phpMyAdmin, certainly did complain. But neither PMA nor any other PHP application ever did anything wrong while handling data.
2. I installed and played around with several versions of the MySQL client. Any client other than the one provided by PHP (even from different, later versions of PHP) did not work.
3. Upgrading PHP to 5.3 is really easy and worked fine. The message was gone after upgrading too.

Bottom line?
You should upgrade PHP. If you're 100% sure you can't, then you can simply ignore the message. As I said before (and as most other people say in several references both in this site and in others), this won't be a problem. It's a warning that PHP & MySQL throw in order to state a given misconfiguration. But it's not a show-stopper.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Avinash ZalaWeb ExpertAuthor Commented:
EXCELLENT

Full marks to you.
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.