求問各位大神，mysql怎么給一個用戶賦予grant權(quán)限
4 回答
慕婉清6462132
TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超2個贊
grant all on *.* to username@'host' identified by 'password'; --授予全部權(quán)限grant all on databasename.* to username@'host' identified by 'password' --授予對某庫的全部權(quán)限grant insert,update,select on databasename.tablename to username@'host' identified by 'password' --授予對某表的部分權(quán)限
- 4 回答
- 0 關(guān)注
- 1408 瀏覽
添加回答
舉報
0/150
提交
取消