• rw1
  • New member
  • Offline
  • Registered: 2012-04-02
  • Posts: 2

Topic: PHP MySQL library version 5.5.11 differs from MySQL server version

hello,

i am on CentOS 6 and have EPEL and remi repositories installed.

i have a message in phpMyAdmin:

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

so i think i have to upgrade my MySQL server version. 

is there a way to do this?

i have found:

http://rpms.famillecollet.com/enterpris … mysql.html

and there is a reference in the FAQ here:

Can MySQL be updated without PHP ?
Yes : compat-mysql51 (fedora 11-14) mysqlclient15 (fedora 8-10 and EL-5) and mysqlclient14 (EL-4) packages provide the connection library for the other packages in the official repository. Yum will handle of this.

but i'm not quite sure how to do this as i am new to CentOS, linux and VPS. 

i have tried:

[root@**** ~]# yum update mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos-mirror.jchost.net
* epel: fedora-epel.mirror.lstn.net
* extras: mirror.raystedman.net
* remi-test: remi-mirror.dedipower.com
* updates: centos.mirror.lstn.net
Setting up Update Process
No Packages marked for Update

if anyone could please provide any instruction it would be much appreciated.

thank you.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: PHP MySQL library version 5.5.11 differs from MySQL server version

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

First, this is only a warning, I haven't encounter any issue with this

...
* remi-test: remi-mirror.dedipower.com
...
No Packages marked for Update

In "remi-test" you only find php (5.4.0), you must also enable "remi" to find mysql.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • rw1
  • New member
  • Offline
  • Registered: 2012-04-02
  • Posts: 2

Re: PHP MySQL library version 5.5.11 differs from MySQL server version

after searching forum i came across a page of results and then went to:

http://forums.famillecollet.com/viewtopic.php?id=82

and tried:

yum --enablerepo=remi update mysql

then restarted apache. 

and it looked like it updated mysql to 5.2.2 in putty (i tried to copy screen results, but highlighted and right-clicked to copy and 'lost' all the screen, windows background smile

then i went to phpmyadmin and had same error message. 

but then i cleared browser cache and the error was gone!

woo hooo!!!!!!!!!!!!!!!!!!!!!!!!!!! smile

4 Reply by rw1 (edited by rw1 2012-04-02 11:12:51)

  • rw1
  • New member
  • Offline
  • Registered: 2012-04-02
  • Posts: 2

Re: PHP MySQL library version 5.5.11 differs from MySQL server version

Remi wrote:

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

First, this is only a warning, I haven't encounter any issue with this

...
* remi-test: remi-mirror.dedipower.com
...
No Packages marked for Update

In "remi-test" you only find php (5.4.0), you must also enable "remi" to find mysql.

oh, thank you for your reply, i didn't see this but was able to figure out a solution!  (see above)

thank you for the information though, i appreciate it!