How to check the MySQL Version

DaRecordon

Well-known member
Registered
Joined
Oct 7, 2016
Messages
242
Points
18
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

Member
Registered
Joined
Apr 28, 2016
Messages
22
Points
0
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!
 

techman

Member
Registered
Joined
Jun 8, 2017
Messages
47
Points
8

overcast

Well-known member
Registered
Joined
Jun 27, 2017
Messages
88
Points
0
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
Registered
Joined
Sep 6, 2017
Messages
3
Points
0
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
Registered
Joined
Sep 1, 2017
Messages
4
Points
0
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.
 
Recommended Threads
Replies
13
Views
8,934
Replies
0
Views
3,026
Replies
3
Views
2,619
Replies
11
Views
2,699

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top