添加mysql用户

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。

2006-09-13 · wuan