本教程操作环境：linux5.9.8系统、mysql 5.7.17版本、dell g3电脑。
查看mysql的版本号1、在命令行登录mysql，即可看到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、利用navicat连接mysql的客户端工具可以查看
连接之后右键——详细信息
3、利用mysql命令查看
mysql> select version();+-----------+| version() |+-----------+| 5.7.17 |+-----------+1 row in set (0.01 sec)mysql>
4
4、在命令行使用status查看
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: 154 questions: 15051829 slow queries: 0 opens: 37599 flush tables: 11 open tables: 1563 queries per second avg: 32.138--------------mysql>
5、使用mysql --help | grep distrib查看
[root@heyong tools]# mysql --help | grep distrib mysql ver 14.14 distrib 5.7.17, for linux-glibc2.5 (x86_64) using editline wrapper
【相关推荐：mysql视频教程】
以上就是怎么查询mysql的版本号的详细内容。