How to login MySQL, help, and select database

Login

In cmd:

> Mysql.exe-uroot-P

> Enter password :********

> Mysql>

 

It's like this:

 
Mysql-uusername-ppassword-hhost
 

Attention: There is no blank after the parameters:-u,-P,-H

 

The mysql client program, also known as the MySQL monitor, is an interface that allows the user to connect to the MySQL server, create and modify databases, and execute queries and view their results. this program is started by executing the command MySQL at the shell prompt. in general, the syntax for this command is:

 
%> MySQL [Options] [database]
 

 
Help
 

 
Help
 

 
%> Mysql-help
 

 
Set Password
 

 
Set Password
 

 
Mysql> set password for 'root' @ 'localhost' = PASSWORD ('secret _ password ');
 

 

Select Database

Select Database

 
%> Mysql-u root-P MySQL
 

1. Mysql> Use mydatabase