How to check MySQL version through shell (SSH) on a Linux Server?
Nixtree
Well-known member
- Joined
- Jul 16, 2016
- Messages
- 133
- Points
- 28
Mysql version is 10.1.22-MariaDB in your case and the second command you need to use
# mysql -u root -p
and then you will be getting a password prompt and give that.
If you are using plesk, then you need to use admin user and admin password
# mysql -u root -p
and then you will be getting a password prompt and give that.
If you are using plesk, then you need to use admin user and admin password
Nixtree
Well-known member
- Joined
- Jul 16, 2016
- Messages
- 133
- Points
- 28
I am pasting all possible options (real time values in one of my test server) and my test cpanel server is having 5.5 mysql version
root@ [~]# mysql --version
mysql Ver 14.14 Distrib 5.5.58, for Linux (x86_64) using readline 5.1
root@[~]# mysql -V
mysql Ver 14.14 Distrib 5.5.58, for Linux (x86_64) using readline 5.1
root@[~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 845832
Server version: 5.5.58-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.5.58 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.58-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)
mysql>
If rpm based installation you can see using the below rpm command as well
root@[~]# rpm -qa |grep MySQL55-
MySQL55-client-5.5.58-1.cp1162.x86_64
MySQL55-server-5.5.58-1.cp1162.x86_64
root@ [~]# mysql --version
mysql Ver 14.14 Distrib 5.5.58, for Linux (x86_64) using readline 5.1
root@[~]# mysql -V
mysql Ver 14.14 Distrib 5.5.58, for Linux (x86_64) using readline 5.1
root@[~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 845832
Server version: 5.5.58-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2017, 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> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.5.58 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.58-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)
mysql>
If rpm based installation you can see using the below rpm command as well
root@[~]# rpm -qa |grep MySQL55-
MySQL55-client-5.5.58-1.cp1162.x86_64
MySQL55-server-5.5.58-1.cp1162.x86_64
Older Threads
Newer Threads
Latest Threads
Recommended Threads
Similar Threads
Latest postsNew threads
-
New threads
-
How much bandwidth is enough for a growing website?
- Started by Ridoy
- Replies: 1
-
-
What are the performance differences between DNS load Balancing and reverse proxy?
- Started by jtti
- Replies: 2
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 supportEssentials Hosting provides reliable and affordable web hosting solutions!- cancan
- Updated:
-
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.Affordable Raspberry Pi & Intel N95 Dedicated Servers with SSD Storage and Unlimited Traffic.- Tinyservers.eu
- Updated:
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
