MariaDB/MySQL : How to get version information
Putting this here for my own future reference. Recently I need to move some databases to a new MariaDB server and part of the migration process requires me to find out the MariaDB version and the OpenSSL version used by MariaDB.
Below are two ways to find out the MariaDB version from console(terminal).
The first method allows us to see the rest of the MariaDB components version.
$ mysql -u root -p
MariaDB [(none)]> SHOW VARIABLES LIKE '%version%';
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| innodb_version | 10.3.15 |
| protocol_version | 10 |
| slave_type_conversions | |
| system_versioning_alter_history | ERROR |
| system_versioning_asof | DEFAULT |
| version | 10.3.15-MariaDB-1:10.3.15+maria~bionic |
| version_comment | mariadb.org binary distribution |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
| version_malloc_library | system |
| version_source_revision | 07aef9f7eb936de2b277f8ae209a1fd72510c011 |
| version_ssl_library | OpenSSL 1.1.1 11 Sep 2018 |
| wsrep_patch_version | wsrep_25.24 |
+---------------------------------+------------------------------------------+
13 rows in set (0.001 sec)
If you only want to know the MariaDB version and not the rest of the, then use this method:
$mysql -V
mysql Ver 15.1 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
See also : How to enable MariaDB/MySQL logs ?
By Adam Ng(黃武俊)
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+6.9k Golang : Test if an input is an Armstrong number example
+10.5k Golang : Format numbers to nearest thousands such as kilos millions billions and trillions
+4.1k Golang : Get a list of crosses(instruments) available to trade from Oanda account
+16.1k Golang : Find file size(disk usage) with filepath.Walk
+31.2k Golang : Convert []string to []byte examples
+8.1k Golang : automatically figure out array length(size) with three dots
+12.6k Golang : Read XML elements data with xml.CharData example
+7.9k Linux/Unix : fatal: the Postfix mail system is already running
+5.9k Golang : Check if password length meet the requirement
+7.1k Golang : Load DSA public key from file example
+35.4k Golang : Convert date or time stamp from string to time.Time type
+8.3k Golang : How to extract video or image files from html source code