MySQL Server Information

| |
SHOW VARIABLES;
SHOW STATUS;
select version();

SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc.
SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc.

References: http://stackoverflow.com/questions/3939803/how-to-get-mysql-server-info-using-command-line

All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.