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: 2020-06-20T11:19:18+05:30

486 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements