开发进行时...

1、连接Mysql
mysql -hip -uusername -ppasswd

2、修改密码
mysqladmin -uusername -poldpasswd password newpasswd
如果没有密码，-poldpasswd可以省略

3、增加新用户
grant select on dbname.* to username@hostname identified by "passwd"
权限可用all表示所有，另有update,delete,insert; "%"表示所有hostname

4、显示
1)show databases;
2)use dbname;
3)show tables;
4)describe tablename;
5)drop database dbname;
6)drop table tablename (if exists tablename);
7)delete from table;truncate table tablename;
8)show character set;
9)show coliation (like 'latin1%')

5、建库
create database dbname (default) CHARACTER SET 字符集;

6、备份导出数据
mysqldump dbname > xxxx.sql

7、导入数据
mysqlimport -uusername -ppasswd < xxx.sql
mysql> source xxx.sql;
mysql -uusername -ppasswd -Ddbname --defualt-character-set utf8 < xxx.sql

8、帮助
mysql> ?
mysql> ? show