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