一是對你的IP 172.16.1.10 進行授權(quán)
grant privileges on dbname.* to "user "@ "172.16.1.10 " identified by "password ";
如果只是你自己用的話就可以這樣寫
grant all on *.* to "user "@ "172.16.1.10" identified by "password ";
grant具體的用法你就參考一下mysql的用戶手冊吧,如果這樣不行的話,就只能通過以下方法進行授權(quán)了
mysql> use mysql;database changed
mysql> desc user; 查看有多少個字段mysql> insert into user values(val1,val2,....);
二是就將root用戶設(shè)為可以遠程登錄,也即是可以從任何機器上登錄
mysql> use mysql;
database changed
mysql> update user set host= "%" where user= "root";
mysql>use mysql
grant all on *.* to "root"@"172.30.41.72" identified by "xcfg304";
restart mysql server
方法三:直接在mysql的數(shù)據(jù)庫管理后臺執(zhí)行:
use mysql;
grant all on *.* to "root"@"172.30.41.95" identified by "xcfg304";
Copyright ? 2019- 91gzw.com 版權(quán)所有 湘ICP備2023023988號-2
違法及侵權(quán)請聯(lián)系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市萬商天勤律師事務(wù)所王興未律師提供法律服務(wù)