• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

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

i see an error message at bottom of my phpmyadmin home page "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.38" .

What does this indicate?
0
young_buddha
Asked:
young_buddha
  • 5
  • 2
2 Solutions
 
vineethvpCommented:
This indicates that the versions of the PHP MySql Library version is different from the MySQL Server version which will not help run any programs. So please reinstall Xamp from http://www.php.net/downloads.php which will have all the updated versions.
0
 
Beverley PortlockCommented:
MySQL needs several pieces of separate software to allow things like PHP to hook up to it. The main MySQL Server itself manages the data in the databases, but PHP needs to know how to "talk" to the main server and a "client" library is often used for this sort of task.

Obviously it is essential that the main server and any client libraries match up with each other - if one offers that the other one does not support then there will be problems.

The error message you have indicates that the two sets of software are out of step with each other. If you are using a Linux distro then check your repository manager to see what version a group of libraries called libmysqlclient*.so are at and see if the repo manage can update them, otherwise full MySQL reinstall (see vineethvp's suggestion) might be the quickest way.
0
 
young_buddhaAuthor Commented:
so far the database is working fine with thousands of records and queries over last two months. Please note  the database and the php installation are on two different servers...
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
young_buddhaAuthor Commented:
also the servers are both running IIS and windows
0
 
young_buddhaAuthor Commented:
as it happens, the versions of mysql and php client library are same but are being shown incorrectly in phpmyadmin


http://bugs.mysql.com/bug.php?id=37705


thanks for your replies.

0
 
young_buddhaAuthor Commented:
actually ignore my last comment, but thanks for your replies.

I think i will go ahead in a few days and install xamp/wamp and have both mysql and php on same server. But it seems to me from reading around on net  that there are some installations of wamp or xamp where there is a mismatch betwen php mysql client library and mysql server version.
0
 
young_buddhaAuthor Commented:
woops i forgot my server is running IIS ..
0
 
Beverley PortlockCommented:
You can install WAMP/XAMPP on your machine and then configure the Apache installation to put Apache on port 81. That leaves port 80 free for IIS.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now