Home>Article>Database> How to check the mysql version?

How to check the mysql version?

青灯夜游
青灯夜游 Original
2019-05-22 18:09:11 86722browse

How to check the mysql version?

How to check the mysql version:

Method 1: Enter the command line and connect to MySQL

mysql -uroot -p123456

You can see the print The output log contains version information [5.7.17]

How to check the mysql version?

Method 2: Use the status command

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

How to check the mysql version?

Method 3: Use the \s command

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

How to check the mysql version?

Method 4: Use sql statement directly to view

select version() from dual;

How to check the mysql version?

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn