How to view MySQL version
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.
