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

Priya Pallavi

Published on 20-Feb-2018 12:29:49

• Related Questions & Answers
• How can I check the status of MySQL Server?
• How can I start MySQL Server?
• How can I shutdown MySQL Server?
• How I can check a Python module version at runtime?
• How To Check MySQL Version
• How can I get the current Android SDK version programmatically?
• How can I know whether MySQL Server is alive or not?
• How to check the system version of Android?
• With JavaScript how can I find the name of the web browser, with version?
• How do I check what version of Python is running my script?
• How Can I check the size of the tables in a particular MySQL database?
• How can we check the default character sets of all the MySQL databases we have on the server?
• How can I get the current Android SDK version programmatically using Kotlin?
• How to check version of python modules?
• How can I handle Server-Sent Events in HTML5?