How to query the version information of mysql in linux

3 query methods: 1. Open the terminal, execute the "mysql -V" command, and check the version information followed by the Distrib keyword in the output result. 2. Open the terminal, execute the "mysql --version" command, and check the version information followed by the Distrib keyword in the output result. 3. Open the terminal, execute "mysql --help |grep Distrib", and check the version information followed by the Distrib keyword in the output result.

The operating environment of this tutorial: linux7.3 system, MySQL version 5, Dell G3 computer.

Three ways to query mysql version information on Linux

##Method 1: Open the terminal and execute the "mysql -V" command (Note: V is capital)

After the command is executed, the effect is as follows (you can see that the MySQL version on the current host is 5.6.42):

Method 2: Open the terminal and execute the "mysql --version" command

After the command is executed, the effect is as follows (you can see that the MySQL version on the current host is 5.6.42):

Method 3: Open the terminal and execute the "mysql --help |grep Distrib" command

After the command is executed, the effect is as follows (You can see that the MySQL version on the current host is 5.7.15):

[Related recommendations:

Linux video tutorial, mysql video Tutorial】

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