- These instructions are intended for checking the MySQL version on your server.
- I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
The following command:
Should return something similar to:
When you connect to MySQL using a command client with the following command, the version of the MySQL server is displayed:
You should receive a result similar to:
Your MariaDB connection id is 2
Server version: 5.5.41-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
The server version in this example is Server version: 5.5.41-MariaDB MariaDB Server.
Once connected to the MySQL Command client, you can also run the command:
SHOW VARIABLES LIKE "%version%";
Which should return a result similar to:
| Variable_name | Value |
| innodb_version | 5.5.40-MariaDB-36.1 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.41-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
7 rows in set (0.10 sec)
Looking for other MySQL tutorials? We have two awesome series! First, Basic Database Interaction. Second, Basic User Interaction. Check them out below!
Try a Free Cloud Server.
Trying a new server is a breeze, and it’ll be up and running in only a few minutes...