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。
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。