Windows10にMariaDBバージョンを確認する方法

環境
windows 10 64 bit
MariaDB 10.6.4

確認方法1

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
MariaDB [(none)]> select version();
+----------------+
| version() |
+----------------+
| 10.6.4-MariaDB |
+----------------+
MariaDB [(none)]> select version(); +----------------+ | version() | +----------------+ | 10.6.4-MariaDB | +----------------+
MariaDB [(none)]> select version();
+----------------+
| version()      |
+----------------+
| 10.6.4-MariaDB |
+----------------+

確認方法2

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
Connection id: 4
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server: MariaDB
Server version: 10.6.4-MariaDB mariadb.org binary distribution
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb3
Db characterset: utf8mb3
Client characterset: cp932
Conn. characterset: cp932
TCP port: 13306
Uptime: 16 hours 55 min 46 sec
MariaDB [(none)]> status -------------- mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca Connection id: 4 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server: MariaDB Server version: 10.6.4-MariaDB mariadb.org binary distribution Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8mb3 Db characterset: utf8mb3 Client characterset: cp932 Conn. characterset: cp932 TCP port: 13306 Uptime: 16 hours 55 min 46 sec
MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca

Connection id:          4
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.6.4-MariaDB mariadb.org binary distribution
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb3
Db     characterset:    utf8mb3
Client characterset:    cp932
Conn.  characterset:    cp932
TCP port:               13306
Uptime:                 16 hours 55 min 46 sec

確認方法3

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
>mysql --version
mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
>mysql --version mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
>mysql --version
mysql  Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca

確認方法4

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
>mysqladmin --version
mysqladmin Ver 9.1 Distrib 10.6.4-MariaDB, for Win64 on AMD64
>mysqladmin --version mysqladmin Ver 9.1 Distrib 10.6.4-MariaDB, for Win64 on AMD64
>mysqladmin --version
mysqladmin  Ver 9.1 Distrib 10.6.4-MariaDB, for Win64 on AMD64

 

MariaDB

Posted by arkgame