授权与收回权限:
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
转载于:https://blog.51cto.com/wangqh/1767913