现在mysql数据库版本号_MySQL如何查看数据库版本号呢?

摘要:

下文讲述MySQL数据库版本号的查看方法，如下所示：

方式1：使用命令行登入MySQL后，会自动显示出其版本信息

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 814562

Server version: 5.1.59 Source distribution

方式2：输入status命令

mysql > status;

./mysql Ver 14.14 Distrib 5.1.59, for unknown-linux-gnu (x86_64) using EditLine wrapper

Connection id: 814562

Current database:

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ”

Using delimiter: ;

Server version: 5.1.59 Source distribution

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: latin1

Conn. characterset: latin1

UNIX socket: /tmp/mysql.sock

Uptime: 45 days 6 hours 57 min 53 sec

Threads: 1 Questions: 16705536 Slow queries: 0 Opens: 137 Flush tables: 1 Open tables: 64 Queries per second avg: 4.269

方式3：输入select version()查询版本信息

mysql >select version();

+———–+

| version() |

+———–+

| 5.1.59 |

+———–+

1 row in set (0.00 sec)