How to check the MySQL Version

DaRecordon · Oct 7, 2016

Are there any commands to check MySQL Version on my VPS Centos? I am new to VPS hosting and just bought a new VPS package to install for testing and hosting my sites on it.

Wesley · Oct 7, 2016

From the Command Line

Type the following command:

Code:

mysql -V

The output can be as follows

root@vps[~]# mysql -V
mysql Ver 14.14 Distrib 5.5.51-38.2, for Linux (x86_64) using readline 5.1

From the MySQL Command Client

If you logged into your VPS and running this Mysql command

Code:

mysql

For example, I can get the output as follows

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9687
Server version: 5.5.51-38.2 Percona Server (GPL), Release 38.2, Revision 6a9ff9a

Copyright (c) 2009-2016 Percona LLC and/or its affiliates
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

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>

When you are prompted at mysql> then you can use this command to show the version of your Mysql

Code:

SHOW VARIABLES LIKE "%version%";

It will show the information you need to know.

For example:

Code:

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------------------------------+
| Variable_name           | Value                                                |
+-------------------------+------------------------------------------------------+
| innodb_version          | 5.5.51-38.2                                          |
| protocol_version        | 10                                                   |
| slave_type_conversions  |                                                      |
| tls_version             | TLSv1.1,TLSv1.2                                      |
| version                 | 5.5.51-38.2                                          |
| version_comment         | Percona Server (GPL), Release 38.2, Revision 6a9ff9a |
| version_compile_machine | x86_64                                               |
| version_compile_os      | Linux                                                |
+-------------------------+------------------------------------------------------+
8 rows in set (0.01 sec)

Hope with these commands you can find out which version of MySQL you are using on your VPS.

Good luck!

maxserver · Jun 7, 2017

mysql -V
or
mysqld -V

techman · Jun 8, 2017

From SSH:

ysql -V

From MySQL Command Client:

mysql

Or just ask your hosting provider, if they're kind enough.

overcast · Jul 11, 2017

Option 1: In case of the command line use the command below.

mysql -V

Option 2: If you are using the CPanel then you can check out the about page of the MySQL wizard or the MySQL database page. You can also do the same on the PHPMyAdmin home page. That should show you the MySQL version installed on your server account.

You can choose either one of the option to look for the mysql version.

gjgcint · Sep 6, 2017

Try this command: mysql -v

This is one is easier. If you have a GUI tool, you can check it in the it under "Server Information". Just make sure that you have admin privileges and you are connected to the server. I hope this helps

kayjay77 · Sep 14, 2017

Hi Gjgcint.

The GUI tool is absolutely considered by many to be much easier to use, than attempting to accomplish the same tasks without the GUI tool. The reason for this is because of what a GUI tool is. A GUI being a Graphical User Interface does just that; it allows users to interact with one another by way of such things such as pictures and animations, as opposed to only text-based commands. An added factor is your kindly reminding us to always first check to verify that we do have administrative privileges; way to go.

24x7serverman · Sep 16, 2017

That's correct!

mysql -V

OR
mysqld -V

These command will provide you the total description of MySQL installed on the server.

How to check the MySQL Version

DaRecordon

Well-known member

Wesley

Member

maxserver

Member

techman

Member

overcast

Well-known member

gjgcint

New member

kayjay77

New member

24x7serverman

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud