希望mysql里面的某個(gè)用戶只有172.29.8.72和192.168.3.39可以連接上，應(yīng)該怎么設(shè)置啊
1 回答
qq_遁去的一_1
TA貢獻(xiàn)1725條經(jīng)驗(yàn) 獲得超8個(gè)贊
GRANT ALL PRIVILEGES ON *.* TO 'username'@'172.29.8.72' IDENTIFIED BY 'password' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.3.39' IDENTIFIED BY 'password' WITH GRANT OPTION;flush privileges;
添加回答
舉報(bào)
0/150
提交
取消