How to check the MySQL Version

DaRecordon

Well-known member
Joined
Oct 7, 2016
Messages
119
Best answers
0
Ratings
3
Points
18
#1
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.
 
Joined
Apr 28, 2016
Messages
22
Best answers
0
Ratings
1
Points
0
#2
From the Command Line

Type the following command:

Code:
mysql -V
The output can be as follows

[email protected][~]# 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!
 
Joined
Jun 8, 2017
Messages
47
Best answers
0
Ratings
4
Points
8
#4

overcast

Well-known member
Joined
Jun 27, 2017
Messages
88
Best answers
0
Ratings
2
Points
0
#5
Option 1: In case of the command line use the command below.

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

New member
Joined
Sep 6, 2017
Messages
3
Best answers
0
Points
0
#6
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

New member
Joined
Sep 1, 2017
Messages
4
Best answers
0
Points
0
#7
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.
 
Newer Threads
Latest Threads
Recommended Threads
Similar Threads

Latest postsNew threads

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads