一是對(duì)你的IP 172.16.1.10 進(jìn)行授權(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的用戶手冊(cè)吧,如果這樣不行的話,就只能通過以下方法進(jìn)行授權(quán)了

mysql> use mysql;database changed

mysql> desc user; 查看有多少個(gè)字段mysql> insert into user values(val1,val2,....);

二是就將root用戶設(shè)為可以遠(yuǎn)程登錄,也即是可以從任何機(jī)器上登錄

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ù)庫管理后臺(tái)執(zhí)行：

use mysql;

grant all on *.* to "root"@"172.30.41.95" identified by "xcfg304";