授权与收回权限:

mysql> grant select,insert on test.* to "user1"@"localhost" identified by "pass";

mysql> revoke insert on test.* from  "user1"@"localhost";

帮助的使用:

按照层次查看帮助:

mysql> ? contents

mysql> ?  Data Types

mysql> ? INT

快速查阅帮助:

mysql> ? show 

mysql> ? create

mysql> ? create TABLE