希望mysql里面的某個用戶只有172.29.8.72和192.168.3.39可以連接上，應(yīng)該怎么設(shè)置啊
1 回答
qq_遁去的一_1
TA貢獻(xiàn)1725條經(jīng)驗 獲得超8個贊
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;
添加回答
舉報
0/150
提交
取消