原文鏈接? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??https://www.cnblogs.com/captainRoB/p/7163871.html
登入數據庫的時候:
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.5.53 ? ?|
+-----------+
row in set (0.00 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.53 ? ?|
+-----------+
row in set (0.00 sec)
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
Windows系統D:/MySQL/bin>mysql -Vmysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)D:/MySQL/bin>mysql --versionmysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)
D:/phpStudy/MySQL/bin>mysql --help | findstr Distribmysql Ver 14.14 Distrib 5.5.53, for Win32 (AMD64)
mysql --help | findstr Distrib //windows終端
mysql --help | grep Distrib //linux終端
新聞熱點
疑難解答