Display the database mysql-> show databases;
Create a database mysql-> Create Database dB;
Delete the database mysql-> drop database dB;
Choose mysql> Use dB.
Create a table mysql-> Create Table mytable (name varchar (20), sex (char (1), birth date );
Delete A Table mysql-> drop table mytable;
Displays the table content mysql-> show tables;
Displays the table structure mysql-> describe mytable;
Add a field mysql-> alter table yourtable add ID int not null auto_increment, add primary key (ID );
Delete a field mysql-> alter table yourtable drop name;
Create a MySQL account mysql> grant all privileges on *. * To '000000' @ 'localhost'-> identified by '20160301 ';
Mysql> grant select, update on *. * To 'monty '@' % '(an account with network access)-> identified by '123 ';
Change the password of an existing account mysql> grant all privileges on *. * To '000000' @ 'localhost'-> identified by '000000'; mysql> flush privileges;