#25721 [Bgs]: wrong MySQL server version info after upgrade from 3.23.57 to 4.0.15

ID: 25721 User updated by: ergin at ergin dot net Reported By: ergin at ergin dot net Status: Bogus Bug Type: MySQL related Operating System: Linux - e-smith RedHat 7.3 based PHP Version: 4.3.3 New Comment: Here are mysql related RPMs on my system [root@erginsme01 root]# rpm -qa|grep mysql php-mysql-4.3.3-1db libdbi-dbd-mysql-0.6.4-2 e-smith-mysql-1.10.0-01 snort-mysql-1.9.0-1snort [root@erginsme01 root]# rpm -qa|grep MySQL MySQL-shared-compat-4.0.15-0 perl-DBD-MySQL-1.2219-6 MySQL-client-4.0.15-0 MySQL-server-4.0.15-0 Previous Comments: ------------------------------------------------------------------------ [2003-10-01 20:46:40] sniper@php.net Recompile PHP. You propably have static build/only static mysql libs there. ------------------------------------------------------------------------ [2003-10-01 17:28:24] pollita@php.net Did you recompile PHP after upgrading MySQL (linking against the new client libraries rather than the bundled client libraries)? (or install a new RPM which uses a PHP which links against MySQL 4 client libraries)? Most likely not. phpMyAdmin is probably reporting the MySQL SERVER version which is not necessarily the same as the MySQL CLIENT version. (MySQL 3.x clients are compatable with MySQL server versions prior to 4.1). Therefore it would be correct that PHP still reports a CLIENT version of 3.23.57 while the PHP script "phpMyAdmin" would get a response of "4.0.15" from the mysql SERVER. ------------------------------------------------------------------------ [2003-10-01 15:57:12] ergin at ergin dot net Description: ------------ phpinfo() shows old mysql version I've recntly upgraded from RHs 3.23.57 RPMs to MySQL's 4.0.15 RPMs. When running phpinfo() it still shows the older version. MySQL Support enabled Active Persistent Links 0 Active Links 1 Client API version 3.23.57 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient ../phpmyadmin/index.php shows the correct version. (lang-swe) Välkommen till phpMyAdmin 2.5.3 MySQL 4.0.15-standard körs på localhost som root@localhost ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=25721&edit=1