mysql -u root -p -e 'status'
もし Pleskをお使いの場合は
mysql -uadmin -p`sudo cat /etc/psa/.psa.shadow` -e 'status'
結果例
mysql Ver 15.1 Distrib 10.1.36-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 33536
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.1.36-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 36 days 16 hours 59 min 3 sec
Threads: 4 Questions: 3939177 Slow queries: 8 Opens: 8496 Flush tables: 1 Open tables: 152 Queries per second avg: 1.242
10.1.36 であることがわかります。