在使用mysql过程中很多小伙伴不知道如何查看mysql版本,下面给大家介绍一下查看mysql版本的四种方法:
方法一:
在终端下:mysql -V,以下是代码片段:
[shengting@login~]$mysql-V mysqlVer14.7Distrib4.1.10a,forredhat-linux-gnu(i686)方法二:
在mysql中:mysql> status;以下是代码片段:
mysql>status; -------------- mysqlVer14.7Distrib4.1.10a,forredhat-linux-gnu(i686) Connectionid:416 SSL:Notinuse Currentpager:stdout Usingoutfile:‘‘ Usingdelimiter:; Serverversion:3.23.56-log Protocolversion:10 Connection:LocalhostviaUNIXsocket Clientcharacterset:latin1 Servercharacterset:latin1 UNIXsocket:/tmp/mysql_3311.sock Uptime:62days21hours21min57sec Threads:1Questions:584402560Slowqueries:424Opens:59664208Flushtables:1Opentables:64Queriespersecondavg:107.551方法三:
在help里面查找,以下是代码片段:
[shengting@login~]$mysql--help|grepDistrib mysqlVer14.7Distrib4.1.10a,forredhat-linux-gnu(i686)方法四:
使用mysql的函数,以下是代码片段:
mysql>selectversion(); +-------------+ |version()| +-------------+ |3.23.56-log| +-------------+ 1rowinset(0.00sec)