PHP MySQL library version / MySQL server version discrepancy on Mac OS X

[Chris Sansom]

On the phpMyAdmin users' forum I found a bunch of threads on this
subject, but all relating to Windows installations - I'm on Mac OS X
10.4.11. I added my question to the most recent thread but got no
response so I'm giving it a shot here.

When I access phpMyAdmin on my local system, I get the message:

"Your PHP MySQL library version 4.1.3-beta differs from your MySQL
server version 5.0.19. This may cause unpredictable behavior."

I need a way of telling the active PHP installation which version of
MySQL I'm using (phpinfo() also shows MySQL as 4.1.3-beta, which I
guess was the default installation with the OS), but I've searched my
hard drive and failed to find any configuration file that contains a
MySQL version number - but maybe this is the wrong way of looking at
it. Any clues?

For what it's worth, this /was/ all running fine until, I suspect, I
did a routine OS update, which reverted the default Apache
installation from 2.x which I'd installed to the default 1.3.41. I
can live with that for the moment, but I think it must also have
reverted a setting somewhere (which I can't find) relating to this
MySQL version - again, I installed the newer 5.0.19 myself and the
system /is/ running that, but PHP evidently thinks otherwise.

I'm hoping that if I can put this right it might stop Firefox 3
throwing up scripting errors!

--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/

Another day, another sausage...
    -- Frank Zappa

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users

[Sebastian Mendel]

Chris Sansom schrieb:

> On the phpMyAdmin users' forum I found a bunch of threads on this
> subject, but all relating to Windows installations - I'm on Mac OS X
> 10.4.11. I added my question to the most recent thread but got no
> response so I'm giving it a shot here.
>
> When I access phpMyAdmin on my local system, I get the message:
>
> "Your PHP MySQL library version 4.1.3-beta differs from your MySQL
> server version 5.0.19. This may cause unpredictable behavior."
>
> I need a way of telling the active PHP installation which version of
> MySQL I'm using (phpinfo() also shows MySQL as 4.1.3-beta, which I
> guess was the default installation with the OS), but I've searched my
> hard drive and failed to find any configuration file that contains a
> MySQL version number - but maybe this is the wrong way of looking at
> it. Any clues?

the reported version is not any configuration switch, it is the version of
the mysql library used when building PHP


> For what it's worth, this /was/ all running fine until, I suspect, I
> did a routine OS update, which reverted the default Apache
> installation from 2.x which I'd installed to the default 1.3.41. I
> can live with that for the moment, but I think it must also have
> reverted a setting somewhere (which I can't find) relating to this
> MySQL version - again, I installed the newer 5.0.19 myself and the
> system /is/ running that, but PHP evidently thinks otherwise.

PHP thinks right, you need to update your mysql client lib used with PHP, or
rebuild PHP

--
Sebastian Mendel

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users

[Chris Sansom]

At 10:39 +0200 9/7/08, Sebastian Mendel wrote:
>the reported version is not any configuration switch, it is the
>version of the mysql library used when building PHP

I see - as I suspected, I was looking at it the wrong way round. I
just couldn't quite see how.

>PHP thinks right, you need to update your mysql client lib used with
>PHP, or rebuild PHP

Yep - thanks!

--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/

To see tomorrow's PC, look at today's Macintosh
    -- Byte 1995

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Phpmyadmin-users mailing list
Phpmyadmin-users@...
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users