Bug #87607 which is the right mysql version
Submitted: 30 Aug 2017 13:18 Modified: 12 Sep 2017 10:57
Reporter: cuishaofei cui Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[30 Aug 2017 13:18] cuishaofei cui
Description:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51b Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1

Connection id:		1
Current database:	niux_yunying
Current user:		test@10.94.49.44
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.0.51b Source distribution
Protocol version:	10
Connection:		10.94.49.44 via TCP/IP
Server characterset:	utf8
Db     characterset:	utf8
Client characterset:	utf8
Conn.  characterset:	utf8
TCP port:		8400
Uptime:			35 days 6 hours 51 min 36 sec

Threads: 77  Questions: 302947325  Slow queries: 1865  Opens: 73304  Flush tables: 1  Open tables: 400  Queries per second avg: 99.369
--------------

mysql> select version();
+------------+
| version()  |
+------------+
| 5.5.35-log |
+------------+
1 row in set (0.00 sec)

mysql> show variables like "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| innodb_version          | 5.5.35              |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.5.35-log          |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | Linux               |
+-------------------------+---------------------+
7 rows in set (0.00 sec)

How to repeat:
status  ;  select verison(); get different version

Suggested fix:
how i can get right version
[30 Aug 2017 13:19] cuishaofei cui
status:
Server version:		5.0.51b Source distribution

different with follows

mysql> show variables like "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| innodb_version          | 5.5.35              |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.5.35-log          |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | Linux               |
+-------------------------+---------------------+
[31 Aug 2017 11:21] Peter Laursen
Maybe this server was upgraded from 5.0x to 5.5x in an incorrect way (for instance not running'mysql_upgrade)?

-- Peter
-- not a MYSQL/Oracle person
[12 Sep 2017 10:57] Miguel Solorzano
Thank you for the bug report. I couldn't repeat with current release:

miguel@miguel-o7:~/files/mysql-5.5.57 $ bin/mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.57 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> status; select version();
--------------
bin/mysql  Ver 14.14 Distrib 5.5.57, for linux-glibc2.12 (x86_64) using readline 5.1

Connection id:          2
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.5.57 MySQL Community Server (GPL)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /tmp/mysql.sock
Uptime:                 8 min 30 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 33  Flush tables: 1  Open tables: 26  Queries per second avg: 0.021
--------------

+-----------+
| version() |
+-----------+
| 5.5.57    |
+-----------+
1 row in set (0.00 sec)

mysql>