MySQL Version anzeigen

Aus dabast Wiki
Version vom 27. April 2020, 15:02 Uhr von Dabast (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „ == Auf der Kommandozeile == $ mysql --version mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 == In MySQL == Log…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen

Auf der Kommandozeile

$ mysql --version
mysql  Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

In MySQL

Login in MySQL

$ mysql -u username -p

Dann:

SHOW VARIABLES LIKE "%version%";

Ausgabe:

+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| immediate_server_version | 999999                       |
| innodb_version           | 8.0.18                       |
| original_server_version  | 999999                       |
| protocol_version         | 10                           |
| slave_type_conversions   |                              |
| tls_version              | TLSv1,TLSv1.1,TLSv1.2        |
| version                  | 8.0.18                       |
| version_comment          | MySQL Community Server - GPL |
| version_compile_machine  | x86_64                       |
| version_compile_os       | Linux                        |
| version_compile_zlib     | 1.2.11                       |
+--------------------------+------------------------------+
11 rows in set (0.00 sec)

oder mit dem Befehl *status*

status
--------------
mysql  Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id:		55972717
Current database:	
Current user:		web190@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server:			MySQL
Server version:		8.0.18 MySQL Community Server - GPL
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/lib/mysql/mysqld.sock
Uptime:			136 days 5 hours 1 min 9 sec

Threads: 20  Questions: 3481894735  Slow queries: 41768  Opens: 80384191  Flush tables: 3  Open tables: 4000  Queries per second avg: 295.866
--------------

Mit MySQLadmin

$ mysqladmin -uusername -p -hlocalhost version
Enter password: 
mysqladmin  Ver 9.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version		8.0.18
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/run/mysqld/mysqld.sock
Uptime:			136 days 5 hours 4 min 37 sec