Shulou(Shulou.com)06/01 Report--

View Mysql database version

I. use the terminal

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

How to use it:

D:\ mysql\ bin > mysql-V

Or

D:\ mysql\ bin > mysql-- version

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

2.MySQL client command: status (abbreviated to\ 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

3. 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

4. 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.

II. Sql command

1. Use the MySQL function: select version ()

two。 Use the MySQL variable: show variables like'% version%'

3. Use the MySQL function: select version ()

Most versatile, it can be executed in MySQL command line clients and various graphics clients

The above is how to view the details of the database version, please pay attention to other related articles!

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.