Shulou(Shulou.com)05/31 Report--

This article mainly explains "mysql how to query the database version", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql how to query the database version" bar!

Methods: 1, use "select version ();" sentence to query; 2, use "show variables like'% version%'" sentence to query; 3, use "status" command to query in mysql client; 4, use "mysql-V" query in terminal.

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

How does mysql query the database version?

1. Use the MySQL function:

Select version ()

2. Use the MySQL variable:

Show variables like'% version%'

3. MySQL client command: status (abbreviated as\ s)

The status (\ s) instruction is the easiest, but it can only be executed in the command line client (MySQL Command Line Client) of MySQL

4. Parameter is-V (uppercase) or-- version

How to use it:

Mysql-V

Or

Mysql-version

Disadvantages can only be executed on the server where Mysql is installed

Expand knowledge:

1. The terminal commands to log in to mysql-u root-p, and the login log also contains the version number.

Disadvantages require reconnection to login

2. Enter rpm-qa at the terminal | grep mysql

This is used to check the version number of the mysql installation package. In fact, it is useless to see the version number of the installation package.

Thank you for reading, the above is the content of "how to query the database version of mysql". After the study of this article, I believe you have a deeper understanding of how to query the database version of mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.