How can I check the version of MySQL Server?

With the help of ‘mysqladmin’ program we would be able to know about the version of our MySQL server. To get the version we should have to write the following command on command line −

C:\mysql\bin>mysqladmin -u root version
mysqladmin Ver 8.42 Distrib 5.7.20, for Win64 on x86_64
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.
Server version       5.7.20
Protocol version     10
Connection           localhost via TCP/IP
TCP port             3306
Uptime:              12 min 54 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 105 Flush tables: 1 Open tables: 98 Queries per second avg: 0.0060

Updated on: 20-Jun-2020


Kickstart Your Career

Get certified by completing the course

Get Started