Start using MySQL in Windows (i)

First, Download:

http://dev.mysql.com/downloads/windows/installer/

Second, after installation can use Workbench for graphical interface integration operation, you can also use command line operation, the following use command line operation.

1, configure environment variables, default MySQL installed in a directory like this: C:\Program Files (x86) \mysql\mysql Workbench CE 6.1.6

2. Link and disconnect the server:

A) Links:

Mysql-h Localhost-u Root-p

Enter password:xxx

Command Description:-H host-u user name-p password

Prompt appears after connection

Mysql>

b) Disconnect

Mysql>quit

3. Get Help

Mysql>help

4. Query version number

Mysql>select version ();

5. Query the current date

Mysql>select current_date;

6. Query the current date and time

Mysql>select now ();

7, query the user name and host

Mysql>select user ();