假如我想设置权限，mysql怎么给一个用户赋予grant权限？

Question

求问各位大神，mysql怎么给一个用户赋予grant权限

Answer 1

grant all on *.* to username@'host' identified by 'password'; --授予全部权限grant all on databasename.* to username@'host' identified by 'password' --授予对某库的全部权限grant insert,update,select on databasename.tablename to username@'host' identified by 'password' --授予对某表的部分权限