net start mysql 在Windows安装mysql服务后，启动mysql服务
mysql –install-maunual
mysql –remove
mysqladmin -u root shutdown
mysql -u root -p -h host
mysql> show databases;
mysql> use mysql
mysql> show tables;
mysql> describe host;
mysqladmin -u user_name -h host_name password "newpwd"
mysql> SET PASSWORD FOR ‘jeffrey’@’%’ = PASSWORD(‘biscuit’);
mysql> CREATE DATABASE db;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
mysql> LOAD DATA LOCAL INFILE ‘/path/pet.txt’ INTO TABLE pet;
mysql> LOAD DATA LOCAL INFILE ‘/path/pet.txt’ INTO TABLE pet
-> LINES TERMINATED BY ‘rn’;
mysql> UPDATE pet SET birth = ‘1989-08-31’ WHERE name = ‘Bowser’;
mysql> SELECT COUNT(*) FROM pet;
mysql> TRUNCATETABLE’sinfo’
从sql_cmd.sql中导入数据库，（sql_cmd.sql可由sql导出）
mysql> source sql_cmd.sql