How to view the version of the mysql connection

This article mainly introduces the method of viewing the connected version of mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The way to view the connection version of mysql: 1, connect MySQL directly on the command line, code is [mysql-uroot-p123456]; 2, use SQL statement directly to view, code is [select version () from dual;].

How to view the version of the mysql connection:

Method 1:

Connect MySQL directly on the command line

Mysql-uroot-p123456

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

The second method:

Is to use the client tool to connect, the editor here uses dbvis

Clicking on the connection will print out the MySQL server version information, which is more or less the same as the first method.

The third method:

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

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

The last method:

In fact, it is a very common method, which is to use SQL statements directly to see the

Select version () from dual

Thank you for reading this article carefully. I hope the editor will share the methods and contents of viewing the mysql connection version to help everyone. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!