Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you information about how to view the mysql software version. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

1. When logging in to the mysql environment, there is a service version number, which is 5.6.22 here.

[root@suzzy ~] # mysql

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 39

Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server-Advanced Edition (Commercial)

Copyright (c) 2000, 2014, 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 >

two。 Use mysql-V to view version information

[root@suzzy] # mysql-V

Mysql Ver 14.14 Distrib 5.6.22, for Linux (x86 / 64) using EditLine wrapper

3. Use mysql-- help to view version information

[root@suzzy ~] # mysql-- help | grep Distrib

Mysql Ver 14.14 Distrib 5.6.22, for Linux (x86 / 64) using EditLine wrapper

[root@suzzy ~] #

4. After entering the mysql command, use the status command

Mysql > status

-

Mysql Ver 14.14 Distrib 5.6.22, for Linux (x86 / 64) using EditLine wrapper

Connection id: 51

Current database:

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile:''

Using delimiter:

Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server-Advanced Edition (Commercial)

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: utf8

Conn. Characterset: utf8

UNIX socket: / var/lib/mysql/mysql.sock

Uptime: 45 days 23 hours 9 min 46 sec

Threads: 1 Questions: 124 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.000

5. Use system functions

Mysql > select version ()

+-+

| | version () |

+-+

| | 5.6.22-enterprise-commercial-advanced |

+-+

1 row in set (0.00 sec)

Mysql > select @ @ version

+-+

| | @ @ version |

+-+

| | 5.6.22-enterprise-commercial-advanced |

+-+

1 row in set (0.00 sec)

6. View variabl

Mysql > show variables like'% version%'

+-+

| | Variable_name | Value |

+-+

| | innodb_version | 5.6.22 | |

| | protocol_version | 10 | |

| | slave_type_conversions |

| | version | 5.6.22-enterprise-commercial-advanced |

| | version_comment | MySQL Enterprise Server-Advanced Edition (Commercial) |

| | version_compile_machine | x86room64 | |

| | version_compile_os | Linux |

+-+

7 rows in set (0.00 sec)

7.mysqladmin command mode

[root@suzzy] # mysqladmin-uroot-p-hlocalhost version

Enter password:

Mysqladmin Ver 8.42 Distrib 5.6.22, for Linux on x86_64

Copyright (c) 2000, 2014, 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.

Server version 5.6.22-enterprise-commercial-advanced

Protocol version 10

Connection Localhost via UNIX socket

UNIX socket / var/lib/mysql/mysql.sock

Uptime: 46 days 7 min 45 sec

Threads: 1 Questions: 133 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.000

Chapter 2.1.1 of the official note

The naming scheme in MySQL 5.6 uses release names that consist of three numbers and a suffix; for example, mysql-5.6.1-m1. The numbers within the release name are interpreted as follows:

The first number (5) is the major version and describes the file format. All MySQL 5 releases have the same file format.

The second number (6) is the release level. Taken together, the major version and release level constitute the release series number.

The third number (1) is the version number within the release series. This is incremented for each new release. Usually you want the latest version for the series you have chosen.

The above is the editor for you to share how to view the mysql software version information, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.