查询方法
1. 命令行登入mysql，在输出的信息中获取版本号；
2. 利用navicat连接mysql，右键选择“详细信息”，在弹窗中查看版本号信息；
3. 执行“select version();”语句来查询；
4. 执行“status”语句来查询。
本教程操作环境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视频教程】