mysql 新建用户,分配权限,以及使用mysql自带的帮助文档

28. October 2016 DataBase 0

创建用户 create user ‘lijian’@’localhsot’ identified  by ”;

授权  grant select,insert,update on lijian.* to ‘lijian’@’localhost’ identified by ”;

取消授权  revoke insert on lijian.* from ‘lijian’@’localhost’;

? contents  查看所有分类   //重不重要不在乎字少,这个命令非常重要。

? int ,? data types 等等,可以具体查看详细信息,(没有文档比这些帮助更有用了!!!)

qq%e6%88%aa%e5%9b%be20161028164706

 

 


Leave a Reply

Your email address will not be published. Required fields are marked *