查看MySQL版本的四种方法

dfsgwe

1、终端下直接使用mysql命令

1 2	[iyunv@localhost lib]# mysql -V mysql  Ver 15.1 Distrib 5.5.47-MariaDB, for Linux (x86_64) using readline 5.1

2、同样在终端使用命令

1 2	[iyunv@localhost lib]# mysql --help | grep Distrib    mysql  Ver 15.1 Distrib 5.5.47-MariaDB, for Linux (x86_64) using readline 5.1

3、登陆mysql之后使用内置命令

1 2 3 4 5 6 7

MariaDB [(none)]> select version(); +----------------+ | version()      | +----------------+ | 5.5.47-MariaDB | +----------------+ 1 row in set (0.00 sec)

4、使用内置命令

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

MariaDB [(none)]> status; -------------- mysql  Ver 15.1 Distrib 5.5.47-MariaDB, for Linux (x86_64) using readline 5.1    Connection id:          4 Current database: Current user:           root@localhost SSL:                    Not in use Current pager:          stdout Using outfile:          '' Using delimiter:        ; Server:                 MariaDB Server version:         5.5.47-MariaDB MariaDB Server 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:                 2 min 56 sec    Threads: 1  Questions: 12  Slow queries: 0  Opens: 0  Flush tables: 2  Open tables: 4  Queries per second avg: 0.068