mysql 查看mysql相關資訊

標籤：utf8   nec   har   lin   mmu   protocol   rac   unit   current   

登入資料庫的時候：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:          11Current database:       mysqlCurrent user:           [email protected]SSL:                    Not in useUsing delimiter:        ;Server version:         5.5.53 MySQL Community Server (GPL)Protocol version:       10Connection:             localhost via TCP/IPServer characterset:    utf8Db     characterset:    utf8Client characterset:    utf8Conn.  characterset:    utf8TCP port:               3306Uptime:                 3 hours 3 min 4 secThreads: 3  Questions: 240  Slow queries: 0  Opens: 49  Flush tables: 1  Open tables: 0  Queries per second avg: 0.021--------------複製代碼  未登入資料庫的時候：mysql -Vmysql --versionD:\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)mysql --help | findstr Distrib　　　　//windows終端mysql --help | grep Distrib　　　　//linux終端D:\phpStudy\MySQL\bin>mysql --help | findstr Distribmysql  Ver 14.14 Distrib 5.5.53, for Win32 (AMD64) 

 

mysql 查看mysql相關資訊