mysql>grant select,insert,update,delete,create,drop on database.employee to user@localhost identified by "123";

给来自localhost的用户user分配可对数据库database的employee表进行select,insert,update,delete,create,drop等操作的权限,并设定口令为123。