如何创建新用户和授予MySQL中的权限
发布网友
发布时间:2022-04-23 00:45
我来回答
共1个回答
热心网友
时间:2022-04-07 22:53
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' --授予对某表的部分权限