Some of MySQL's operations

Servives.msc the computer service to run, you can check the MySQL boot situation.

net stop MySQL stop MySQL run
net start MySQL startup MySQL

Note: Sometimes it takes an administrator's identity, otherwise it doesn't work.

There are two ways of doing this:
1 Connect to database: mysql-u+ user name-p+ user password-hlocalhost-p3306 (not local-H and-P)
mysql-uroot-padmin-h127.0.0.1-p3306

If you are accessing locally, you do not need to add-H and-p

2 after the installation of MySQL will automatically produce a command window, can be used directly.

Open the database service:
show databases;
Use a database:
Use database MySQL;
To view the tables for the database:
Show tables;
Create a new database:
Create Database demobase;
To delete a database:
Drop database demobase;

Note the semicolon ";".

Some of MySQL's operations