《Mysql實(shí)例給Mysql添加遠(yuǎn)程訪問權(quán)限的方法》要點(diǎn):
本文介紹了Mysql實(shí)例給Mysql添加遠(yuǎn)程訪問權(quán)限的方法,希望對(duì)您有用。如果有疑問,可以聯(lián)系我們。
user:myuser? pwd:mypassword 從任何主機(jī)連接到mysql服務(wù)器MYSQL數(shù)據(jù)庫(kù)
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;MYSQL數(shù)據(jù)庫(kù)
user:myuser? pwd:mypassword 從192.168.1.3連接到mysql服務(wù)器MYSQL數(shù)據(jù)庫(kù)
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;MYSQL數(shù)據(jù)庫(kù)
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址:
http://www.snjht.com/jiaocheng/1674.html