MySQL Admin Commands
MySQL Admin Commands:
* Statistics: [prompt]$ mysqladmin version
* List database environment: [prompt]$ mysqladmin variables
* Show if database is running: [prompt]$ mysqladmin ping
* Show databases available:
[prompt]$ mysqlshow
OR
mysql> SHOW DATABASES;
* Delete database: mysql> drop database databasename;
* Show list of active threads in server:
[prompt]$ mysqladmin -h localhost -u root -p processlist
* Delete a database: [prompt]$ mysqladmin drop database-name
* Execute SQL from Linux command line interface:
[prompt]$ mysql -h localhost -u root -p -e “select host,db,user from db” mysql
* Execute SQL command file from Linux command line interface:
[prompt]$ mysql -h localhost -u root -p database-name
