How to check the MySQL version?

To check the version of MySQL, there are mainly the following methods. If you are interested, you may try it

To check the version of MySQL, there are mainly the following methods Method:

#1. I want to check the MySQL version without connecting to the MySQL server. Open cmd, switch to the bin directory of mysql, and run the following command:

e:\mysql\bin>mysql -V

mysql Ver 14.14 Distrib 5.6.32, for Win32 (AMD64)

（Version is 5.6.32）

Or:

e:\mysql\bin>mysql -v

This command can view more detailed information, because it will use the account ODBC to connect to the MySQL server and connect to port 3306 on localhost by default.

Or:

e:\mysql\bin>mysql --help | find "Distrib"

mysql Ver 14.14 Distrib 5.6 .32, for Win32 (AMD64)

This method is only available under windows system, because the find command is used to find strings in windows, and the following strings must be wrapped in double quotes, while in linux systems Although | is also used as the pipe character below, the grep command is used to find the string (such as: mysql --help | grep Distrib).

2. If you are already connected to the MySQL server, run the following command:

mysql> select version();

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

| version() |

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

| 5.6.32-log |

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

1 row in set (0.00 sec)

Or:

mysql> status;

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

mysql Ver 14.14 Distrib 5.6. 32, for Win32 (AMD64)

Connection id:   9

Current database:

Current user:                                 9 SSL: Not in useUsing delimiter: ;

Server version: 5.6.32-log MySQL Community Server (GPL)

Protocol version: 10

Connection: localhost via TCP/IP

Server characterset: latin1

Db characterset: latin1

##Conn. characterset: gbk

TCP port: 3307

Uptime: 4 hours 7 min 11 sec

Threads: 4  Questions: 126  Slow queries: 0  Opens: 73  Flush tables: 1  Open tables: 66  Queries per second avg: 0.008

或者：

mysql> \s

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

mysql  Ver 14.14 Distrib 5.6.32, for Win32 (AMD64)

Connection id:          9

Current database:

Current user:           root@localhost

SSL:                    Not in use

Using delimiter:        ;

Server version:         5.6.32-log MySQL Community Server (GPL)

Protocol version:       10

Connection:             localhost via TCP/IP

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    gbk

Conn.  characterset:    gbk

TCP port:               3307

Uptime:                 4 hours 9 min 29 sec

Threads: 4  Questions: 144  Slow queries: 0  Opens: 73  Flush tables: 1  Open tables: 66  Queries per second avg: 0.009

3. 在命令行连接上MySQL服务器时，其实就已经显示了MySQL的版本，如：

e:\mysql\bin>mysql -uroot -p -P3307

Enter password:

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

Your MySQL connection id is 10

Server version: 5.6.32-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

以上就是我整理到的，查看mysql当前版本的几种方法，希望会对大家有帮助。

相关文章：

如何在一台windows主机上实现MySQL的主从复制？

Mysql创建外键约束的两种方式

MySQL string interception and interception characters for query

The above is the detailed content of How to check the MySQL version?. For more information, please follow other related articles on the PHP Chinese website!