Following is a list of some of mysql specific commands that I frequently use. You should be connected to mysql server through the command-line to execute the commands.
Display the list of databases hosted by the mysql server
Selects the database to be working on.
Describes the metadata of the table;
Display tables of the selected database
execute an SQL script file