求問各位大神，mysql怎么給一個用戶賦予grant權限
4 回答
慕婉清6462132
TA貢獻1804條經驗 獲得超2個贊
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' --授予對某表的部分權限
- 4 回答
- 0 關注
- 1410 瀏覽
添加回答
舉報
0/150
提交
取消