「Windows10」MySQLのバージョンを確認する方法
環境
Windows 10 Home 64bit
MySQL 8.0.27
方法1
「version()」を利用してMySQLのバージョンを確認します。
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.27 |
+-----------+
1 row in set (0.08 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.27 |
+-----------+
1 row in set (0.08 sec)
mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.27 | +-----------+ 1 row in set (0.08 sec)
方法2
「status」を利用してMySQLのバージョンを確認します。
mysql> status
--------------
mysql Ver 8.0.27 for Win64 on x86_64 (MySQL Community Server - GPL)
Connection id: 8
Current database:
Current user: root@localhost
SSL: Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter: ;
Server version: 8.0.27 MySQL Community Server - GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: cp932
Conn. characterset: cp932
TCP port: 3306
Binary data as: Hexadecimal
Uptime: 1 day 22 hours 28 min 9 sec
mysql> status
--------------
mysql Ver 8.0.27 for Win64 on x86_64 (MySQL Community Server - GPL)
Connection id: 8
Current database:
Current user: root@localhost
SSL: Cipher in use is TLS_AES_256_GCM_SHA384
Using delimiter: ;
Server version: 8.0.27 MySQL Community Server - GPL
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: cp932
Conn. characterset: cp932
TCP port: 3306
Binary data as: Hexadecimal
Uptime: 1 day 22 hours 28 min 9 sec
mysql> status -------------- mysql Ver 8.0.27 for Win64 on x86_64 (MySQL Community Server - GPL) Connection id: 8 Current database: Current user: root@localhost SSL: Cipher in use is TLS_AES_256_GCM_SHA384 Using delimiter: ; Server version: 8.0.27 MySQL Community Server - GPL Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: cp932 Conn. characterset: cp932 TCP port: 3306 Binary data as: Hexadecimal Uptime: 1 day 22 hours 28 min 9 sec