MySQL Bugs: #37705: Installed MySQL 5.0.51a but phpMyAdmin tells me the MySQL Server is 3.23.32

Bug #37705	Installed MySQL 5.0.51a but phpMyAdmin tells me the MySQL Server is 3.23.32
Submitted:	28 Jun 2008 2:53	Modified:	28 Jun 2008 14:48
Reporter:	MagicMan -	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.51a	OS:	Windows (XP Pro SP3)
Assigned to:		CPU Architecture:	Any
Tags:	library version, MySQL server version, wrong version

Description:
Your PHP MySQL library version 5.0.51 differs from your MySQL server version 3.23.32. This
may cause unpredictable behavior.

The version shown on the main page in phpMyAdmin is wrong. I installed mysql 5.0.33 and 5.0.51a and it
says both times "Server Version: 3.23.32" in phpmyadmin.

important to know: i am logged in as root from another computer than the localhost! This
is important to know, because when i login in phpmyadmin on the localhost, the shown
version is right!

This bug happened only if you are using phpmyadmin and connected to a different computer with mysql version (5.0.33/51a)

(the phpmyadmin version was on both computers in both tests the same with
MySQL-Client-Version: 5.0.51)

(source: xampp installation 1.6.0a and 1.6.6a)

it's showing the right version, if you are using "select version()"

How to repeat:
1. install mysql 5.0.33 or 5.0.51a on a computer in your network
2. install phpmyadmin with MySQL-Client-Version 5.0.51 on another computer
3. config the config.inc.php so, that you can connect to the other computer
4. login as root on the computer with phpmyadmin => shows you the wrong version (select version() will show the right version)

(php version is 5)

Thank you for the bug report. Could you please instead to connect with phpMyAdmin, connect using the mysql.exe client and issue the bellow command:

mysql> show variables like "%version%";
+-------------------------+-------------------------------+
| Variable_name           | Value                         |
+-------------------------+-------------------------------+
| protocol_version        | 10                            |
| version                 | 5.0.51b-community-nt          |
| version_comment         | MySQL Community Edition (GPL) |
| version_compile_machine | ia32                          |
| version_compile_os      | Win32                         |
+-------------------------+-------------------------------+
5 rows in set (0.00 sec)

mysql>

Thanks in advance.

Connected on localhost (root) with mysql.exe:

Server version: 5.0.51a Source distribution
mysql> show variables like '%version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.0.51a             |
| version_comment         | Source distribution |
| version_compile_machine | ia32                |
| version_compile_os      | Win32               |
+-------------------------+---------------------+
5 rows in set (0.00 sec)

=================================================

Connected from another computer (root) with mysql.exe:

Server version: 5.0.51a Source distribution
mysql> show variables like '%version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.0.51a             |
| version_comment         | Source distribution |
| version_compile_machine | ia32                |
| version_compile_os      | Win32               |
+-------------------------+---------------------+
5 rows in set (0.00 sec)

=================================================

-> same results

Thank you for the feedback. So there is not a bug, please verify your phpMyAdmin client.

- phpMyAdmin bug #1875010 [auth] MySQL server and client version mismatch (mysql ext.)
Link to phpMyAdmin bug #1875010: https://sourceforge.net/tracker/index.php?func=detail&aid=1875010&group_id=23067&atid=3774...

Problem Solved -> Newest phpMyAdmin (2.11.7)

I have recently installed WAMPSERVER 2.0e [12/05/08] (from http://www.wampserver.com/) which includes Apache 2.2.10, MySQL 5.1.30, PHP 5.2.7.
Server - localhost, WEB browser - Firefox.
After starting the WAMPSERVER and selecting phpMyAdmin from its menu a new Firefox TAB) "http://localhost/phpmyadmin/" was opened which looked okay besides the message "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.30. This may cause unpredictable behavior."

What should I update and from where?

MySQL
    * Server: localhost via TCP/IP
    * Server version: 5.1.30-community-log
    * Protocol version: 10
    * User: root@localhost
    * MySQL charset: UTF-8 Unicode (utf8)
Web server
    * Apache/2.2.10 (Win32) PHP/5.2.7
    * MySQL client version: 5.0.51a
    * PHP extension: mysqli
phpMyAdmin
    * Version information: 3.0.1.1