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