How to Check MySQL Version in Ubuntu Linux

This brief tutorial shows students and new users how to check MySQL | MariaDB server versions in Ubuntu Linux.

How do you know which versions of MySQL or MariaDB database server you’re running? How do you find out? What command do you use?

The answer for all your questions detailed below.

Nowadays, everywhere you look you’ll find MariaDB database server being used with many opensource projects. This was not the case few years ago.

Then, MySQL was the probably the only database server used in majority of the opensource projects. However, licensing changes made by Oracle, the new parent company established an alternative to MySQL called MariaDB.

MariaDB is a drop-in replacement for MySQL. This means that for many cases, you can just uninstall MySQL and install MariaDB and you are good to go. There is not generally any need to convert any data files.

Whatever database you use, the commands below should work in finding out the version of MySQL or MariaDB.

To get started with checking MySQL or MariaDB database versions, follow the steps below:

Check MySQL Server version

MySQL and MariaDB come with a built-in tool that allows you to check the server versions. Simply run the commands below with the -d argument to display the current version of the server.

mysqld --version

Running the command above will show which version the server is running.

MySQL output:
/usr/sbin/mysqld  Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

MariaDB output:
mysqld  Ver 10.3.25-MariaDB-0ubuntu0.20.04.1 for debian-linux-gnu on x86_64 (Ubuntu 20.04)

If you run the commands below, is should also display the server version

mysqladmin -V

Output from the command above.

MySQL output:
mysqladmin  Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

MariaDB output:
mysqladmin  Ver 9.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu on x86_64

MySQL and MariaDB come with client tool that also should help you finding the server version. From the command line, invoke the client tool by running the command below:

sudo mysql

That will allow you to login and display the server details including version number.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.23-0ubuntu0.20.04.1 (Ubuntu)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> 

MariaDB server will output the message below:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 49
Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

Or run the STATUS query to display the sever details including the version number.

mysql> STATUS;

That should display the output below:

Connection id:        9
 Current database:    
 Current user:        root@localhost
 SSL:            Not in use
 Current pager:        stdout
 Using outfile:        ''
 Using delimiter:    ;
 Server version:        8.0.23-0ubuntu0.20.04.1 (Ubuntu)
 Protocol version:    10
 Connection:        Localhost via UNIX socket
 Server characterset:    utf8mb4
 Db     characterset:    utf8mb4
 Client characterset:    utf8mb4
 Conn.  characterset:    utf8mb4
 UNIX socket:        /var/run/mysqld/mysqld.sock
 Binary data as:        Hexadecimal
 Uptime:            6 min 54 sec
 Threads: 2  Questions: 5  Slow queries: 0  Opens: 117  Flush tables: 3  Open tables: 36  Queries per second avg: 0.012

These methods are few that help you determine the server version of MySQL or MariaDB from the command line console.

Using phpMyAdmin

If you have phpMyAdmin installed, you should also be able to see the server version from the portal. Login and view the server detail from the dashboard.

Using PHP

If you can upload file to your web root directory, simply create a local file called mysqlversion.php. Then copy and paste the code below into the file and upload it to your server root folder.

<?php

// Create a database connection.
$link = mysqli_connect("localhost", "root", "root_password");

// Print the MySQL version.
echo mysqli_get_server_info($link);

// Close the connection.
mysqli_close($link);

Then browser to the server hostname or IP address followed by mysqlversion.php

http://localhost/mysqlversion.php

That will display your server version.

There might be other ways to view your database server version number in Ubuntu Linux. However, the few methods above should get you started.

Conclusion:

This post showed you how to find the version number of MySQL or MariaDB database server in Ubuntu Linux. If you find any error above, please use the comment form below to report.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.