Shulou(Shulou.com)06/01 Report--

Below to understand the MySQL version view method, I believe that everyone will definitely benefit a lot after reading, the text is not more refined, I hope MySQL version view method This short content is what you want.

1. Without connecting to MySQL Cloud Virtual Machine, you want to check MySQL version. Open cmd, switch to mysql bin directory, run the following command:

e:\mysql\bin>mysql -V

mysql Ver 14.14 Distrib 5.6.32, for Win32 (AMD64)

(Version 5.6.32)

Or:

e:\mysql\bin>mysql -v

This command can be viewed in more detail because it connects to MySQL Cloud Virtual Machine with ODBC account, which connects 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 windows only use the find command to find strings, and the strings behind must be wrapped in double quotes, while linux system is also used.| As a pipe character, use grep command to find string (e.g. mysql --help| grep Distrib）。

2. If you are already connected to MySQL Cloud Virtual Machine, 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: 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 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

Or:

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. When connecting MySQL Cloud Virtual Machine on the command line, MySQL version is already displayed, such as:

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.

After reading MySQL version view method this article, many readers will definitely want to know more related content, if you want to get more industry information, you can pay attention to our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.