mysqladmin command and mysqlshow command usage and examples

mysqladmin command

1)Change MySQL root password 

mysqladmin -u root -ptmppassword password 'newpassword'

2) Check MySQL server is up or not 

mysqladmin -u root -p ping

3) Find MySQL server version 

mysqladmin -u root -ptmppassword version

4) Show the current MySQL servers status

mysqladmin -u root -ptmppassword status

5) Find the values of status variables

mysqladmin -u root -ptmppassword extended-status

6) Find the values of MySQL system variables 

mysqladmin  -u root -ptmppassword variables

7) Show all the running process/queries in MySQL databases 

mysqladmin -u root -ptmppassword processlist

8) Create MySQL database 
mysqladmin -u root -ptmppassword create testdb

9) Delete database 

mysqladmin -u root -ptmppassword drop testdb

10) Shutdown the MySQL server 

mysqladmin -u root -ptmppassword shutdown

11) Kill MySQL client process

mysqladmin -u root -ptmppassword kill 20

(20 is the process id with the process list) 

mysqlshow command

1) Show all the databases 

mysqlshow  -u root -ptmppassword

2) Show the tables on a database 

mysqlshow -v -v -u root -ptmppassword mydb_name