How to view mysql versions

Method 1:

1: On a terminal or windows:Mysql-VYou can.



It can be seen that the version is mysql Ver 14.14 Distrib 5.1.42, for Win32 (ia32), where 5.1.42 is the version.

Type 2: in mysql:Mysql> status;This operation can be performed only after logon.
Mysql-u root-p
Password;
Shows the effect:


Third: use mysql FunctionsSelect version ();
Shows the effect.


Method 4: Search in help, which is divided into windows and linux

Run the following command in windows:Mysql -- help | find "Distrib"

Run the following command in linux:Mysql -- help | grep Distrib