-- MySQL client's most useful commands I--

mysql (client)

status;

SELECT VERSION(); - (MySQL Server version)

SELECT CONNECTION_ID();

SELECT DATABASE();

SELECT USER();

SELECT CURRENT_USER();

SHOW DATABASES;

USE dbname

SHOW TABLES

SHOW COLUMNS FROM tblname >> DESCRIBE tblname

SHOW CREATE TABLE tblname;

SHOW PROCESSLIST;

SHOW PRIVILEGES;

SHOW GRANTS FOR username;

mysqladmin

mysqladmin –version - (MySQL Client version)

mysqladmin -u root -p -i 2 processlist

mysqladmin -u user -p -i 5 status

mysqladmin -u user -p -i 5 variables

mysqladmin -u user -p flush-privileges

mysqladmin -u user -p kill xxIDxx

Note: Please replace user, xxx, xxIDxx etc. with your values.

“Telnet 192.168.1.1 3306” will show you if the MySQL server is alive and print also the version.