Four ways to view MySQL version

1. use mysql command directly under Terminal

[[email protected] lib]# mysql-vmysql Ver 15.1 distrib 5.5.47-mariadb, for Linux (x86_64) using ReadLine 5.1

2. same command in terminal use

[[email protected] lib]# MySQL--help | grep distrib mysql Ver 15.1 distrib 5.5.47-mariadb, for Linux (x86_64) using ReadLine 5.1

3. use built-in commands after logging in to MySQL

MariaDB [(None)]> select version (); +----------------+| Version () |+----------------+| 5.5.47-MARIADB |+----------------+1 row in Set (0.00 sec)

4. using built-in commands

mariadb [(None)]> status;--------------mysql  ver 15.1 distrib 5.5.47- mariadb, for linux  (x86_64)  using readline 5.1 Connection id:           4Current database:Current user:            [email protected]SSL:                     Not in  Usecurrent pager:          stdoutusing outfile:            ' using delimiter:         ; server:                  mariadbserver version:         5.5.47-mariadb mariadb& nbsp; serverprotocol version:       10connection:              Localhost via UNIX socketServer  characterset:    latin1db     characterset:     latin1Client characterset:    utf8Conn.  characterset:     utf8unix socket:            /var/ lib/mysql/mysql.sockuptime:                  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

This article is from the "Work hard" blog, please be sure to keep this source http://amyhehe.blog.51cto.com/9406021/1761240

Four ways to view MySQL version