
创建用户并授权:
GRANT permissions on datebase.tables to 'username'@'permittedhost' identified by 'password';
//在数据库messageBoard上创建密码为1111的admin帐号
GRANT CREATE,DROP,SELECT,UPDATE,INSERT,DELETE ON messageBoard.* to 'admin'@'localhost' idetified by '1111';
//创建普通用户
GRANT SELECT,UPDATE,INSERT,DELETE ON messageBoard.* to 'normal_user'@'localhost' identified...