MySQL Basic Commands

Accessing MySQL First Time 
To access MySQL the first time simply by typing mysql in the system propt. 
General form: mysql database-h host-u user-p password;
If using xampp you must first enter into the mySQL folder. Eg MySQL are in the directory C: \> xampp \ mysql \ bin, then you have to get into that directory.
A common form in xampp: mysql-u user-p password;Example: mysql-u root-p 
Root is the user, While the password blank.
Displays Help
 MySQL has a simple help facility (HELP) which can be activated by typing mysql mysql-help or-h;
Knowing MySQL Version 
To be able to find out which used the MySQL version you can use the following command:Select version ();
Featured Database 
The general form of the command:show databases;
Countermand For orders that have already cancel we type (but not yet pressed the ENTER key), just add "\ c" to the end of the order and followed by pressing the ENTER key. 
GiveNotes or Comments 
Giving a note or comment on MySQL is done by giving the prefix / suffix * and * / or prefix # on line comment
Example:Mysql> / * The command below to display thedatabase * /SHOWDATABASES;