Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to view the mysql version, Xiaobian thinks it is quite practical, so share it for everyone to make a reference, I hope you can gain something after reading this article.

How to view mysql version:

Method 1: Enter command line and connect MySQL

mysql -uroot -p123456

You can see that the printed log contains version information [5.7.17]

Method 2: Use the status command

After connecting to MySQL, enter status to view version information, as shown in the following figure

Method 3: Use\s command

Enter\s to achieve the same effect as in the previous step

Method 4: Use SQL statement directly to view

select version() from dual;

About how to view mysql version to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.