MySQL Admin Command
Once you install MySQL on your Microsoft Windows operating system, you can reach the command line by going to the Start Menu and choosing [Run]. Type the keyword [cmd] into the text field and press Enter to launch Window’s command line interface.
Here are the command you can execute through Admin Panel ( 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
