How do I check the version of MySQL server?

With the help of ‘mysqladmin’ program we will be able to know the version of our MySQL server. To get the version, we need to enter the following command in the 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

The above is the detailed content of How do I check the version of MySQL server?. For more information, please follow other related articles on the PHP Chinese website!