MySql Commands

Mysql commands:
 1- how to check   Mysql server running status
  #mysqladmin -u root -p ping
Enterpassword: mysql password 
 Mysql is alive -


2- how to check the Mysql Version 
  #mysqladmin -u root -p version 

3- how to check the current status of Mysql server
 #mysqladmin -u root -ptmppassword status 


4 - how to check all the running process in Mysql
 #mysqladmin -u root -p processlist 


5- how to check, repair, & optimize all tables in all databases 
 #mysqlcheck -u root -p --auto-repair --check --optimize --all-database