如何找出MySQL服务器版本号

时间:2020-01-09 10:42:44  来源:igfitidea点击:

如何在UNIX/Linux操作系统下找出mysql服务器的版本号?
您可以使用mysqladmin命令从服务器获取版本信息,如下所示。
打开终端并输入以下命令(用于通过ssh会话登录远程服务器):

$ mysqladmin -u root -p version

输出示例:

Enter password: 
mysqladmin  Ver 8.41 Distrib 5.0.77, for redhat-linux-gnu on x86_64
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version		5.0.77
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			1 day 16 hours 37 min 50 sec

Threads: 2  Questions: 32558157  Slow queries: 0  Opens: 2992  Flush tables: 1  Open tables: 1684  Queries per second avg: 222.589