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

This article is about how to query the version number of mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Query method: 1, command line login mysql, get the version number in the output information; 2, use navicat to connect mysql, right select "details", view the version number information in the pop-up window; 3, execute "select version ();" statement to query; 4, execute "status" statement to query.

The operating environment of this tutorial: linux5.9.8 system, mysql version 5.7.17, Dell G3 computer.

Check the version number of mysql

1. Log in to mysql on the command line to see the version number of mysql

[root@heyong] # mysql-uroot-pEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 487032Server version: 5.7.17 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >

2. The client tool that uses navicat to connect to mysql can view

Right-click after connection-- details

3. Use the mysql command to view

Mysql > select version (); +-+ | version () | +-+ | 5.7.17 | +-+ 1 row in set (0.01sec) mysql >

four

4. Use status on the command line to view

Mysql > status-mysql Ver 14.14 Distrib 5.7.17, for linux-glibc2.5 (x86 / 64) using EditLine wrapperConnection id: 488398Current database: Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile:''Using delimiter: Server version: 5.7.17 MySQL Community Server (GPL) Protocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. Characterset: utf8UNIX socket: / tmp/mysql.sockUptime: 5 days 10 hours 5 min 40 secThreads: 154Questions: 15051829 Slow queries: 0 Opens: 37599 Flush tables: 11 Open tables: 1563 Queries per second avg: 32.138-mysql >

5. Use mysql-- help | grep Distrib to view

[root@heyong tools] # mysql-- help | grep Distrib mysql Ver 14.14 Distrib 5.7.17, for linux-glibc2.5 (x86 / 64) using EditLine wrapper

Thank you for reading! This is the end of the article on "how to query the version number of mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.