1、設(shè)置用戶對(duì)redmine1數(shù)據(jù)庫(kù)有增加刪除修改查看權(quán)限。 grant select,insert,update,delete on redmine1.* to user@"192.168.1.1" identified by "passwd";
2、新增超級(jí)權(quán)限并允許遠(yuǎn)程訪問: GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
3、刷新權(quán)限 FLUSH PRIVILEGES;
|
2006-2014 IT0355.com 山西中聯(lián)科創(chuàng)科技有限公司. All Rights Reserved.
電話:0355-3728808 傳真:0355-3728808
ICP備案號(hào):晉ICP備06003721號(hào)本站已通過國(guó)際W3C認(rèn)證
關(guān)鍵字:中聯(lián)科創(chuàng),長(zhǎng)治網(wǎng)站建設(shè),長(zhǎng)治網(wǎng)站推廣,長(zhǎng)治網(wǎng)絡(luò)工程,長(zhǎng)治軟件開發(fā),山西網(wǎng)站建設(shè),山西軟件開發(fā) 長(zhǎng)治五金網(wǎng)