MySQLのバージョン確認方法

接続前なら

  $ mysql --version
  mysql  Ver 14.14 Distrib 5.7.21, for osx10.13 (x86_64) using  EditLine wrapper

接続後なら

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

mysqladminやstatusを使えばより詳細に色々分かる。

接続前

  $ mysqladmin version
  mysqladmin  Ver 8.42 Distrib 5.7.21, for osx10.13 on x86_64
  Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

  Oracle is a registered trademark of Oracle Corporation and/or its
  affiliates. Other names may be trademarks of their respective
  owners.

  Server version		5.7.21
  Protocol version	10
  Connection		Localhost via UNIX socket
  UNIX socket		/tmp/mysql.sock
  Uptime:			4 min 53 sec

  Threads: 1  Questions: 2  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 98  Queries per second avg: 0.006

接続後

  mysql> status
  --------------
  mysql  Ver 14.14 Distrib 5.7.21, for osx10.13 (x86_64) using  EditLine wrapper

  Connection id:		3
  Current database:
  Current user:		root@localhost
  SSL:			Not in use
  Current pager:		stdout
  Using outfile:		''
  Using delimiter:	;
  Server version:		5.7.21 Homebrew
  Protocol version:	10
  Connection:		Localhost via UNIX socket
  Server characterset:	utf8
  Db     characterset:	utf8
  Client characterset:	utf8
  Conn.  characterset:	utf8
  UNIX socket:		/tmp/mysql.sock
  Uptime:			6 min 14 sec

  Threads: 1  Questions: 7  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 98  Queries per second avg: 0.018
  --------------

おしまい。