Mysql之查看数据库版本

Mysql版本：

登入数据库的时候：

select @@version;

select version();

mysql> select @@version;

+-----------+

| @@version |

+-----------+

| 5.5.53    |

+-----------+

1 row in set (0.00 sec)

mysql> select version();

+-----------+

| version() |

+-----------+

| 5.5.53    |

+-----------+

1 row in set (0.00 sec)

status;

mysql> status;

--------------

mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

Connection id:          11

Current database:       mysql

Current user:           root@localhost

SSL:                    Not in use

Using delimiter:        ;

Server version:         5.5.53 MySQL Community Server (GPL)

Protocol version:       10

Connection:             localhost via TCP/IP

Server characterset:    utf8

Db     characterset:    utf8

Client characterset:    utf8

Conn.  characterset:    utf8

TCP port:               3306

Uptime:                 3 hours 3 min 4 sec

Threads: 3  Questions: 240  Slow queries: 0  Opens: 49  Flush tables: 1  Open tables: 0  Queries per second avg: 0.021

--------------

未登入数据库的时候：

mysql -V

mysql --version

D:\MySQL\bin>mysql -V

mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

D:\MySQL\bin>mysql --version

mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

mysql --help | findstr Distrib　　　　//windows终端

mysql --help | grep Distrib　　　　//linux终端

D:\phpStudy\MySQL\bin>mysql --help | findstr Distrib

mysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)

巴特西

Mysql之查看数据库版本

最新文章

热门文章