How to check mysql connection version

How to check the mysql connection version: 1. Directly connect to MySQL on the command line, the code is [mysql -uroot -p123456]; 2. Directly use the sql statement to view, the code is [select version() from dual ;].

How to check the mysql connection version:

Method 1:

Connect MySQL directly from the command line

mysql -uroot -p123456

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

Two methods:

is to use the client tool to connect. The editor here uses dbvis

Clicking the connection will print out MySQL The server version information is similar to the first method.

The third method:

After connecting to MySQL, you can also view the version information by entering status, as shown in the figure below Show

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

The last method :

In fact, it is a very conventional method, which is to directly use sql statements to view

select version() from dual;

related free learning recommendations : mysql database(Video)

The above is the detailed content of How to check mysql connection version. For more information, please follow other related articles on the PHP Chinese website!