???????

??????MySQL Adminstrator GUI Tool????MySQL Server??Server????????????Host ??60-248-32-13.HINET-IP.hinet.net?? is not allowed to connect to this MySQL server

?????????????????????????￡?

shell>mysql --user=root -p

????????

mysql>use mysql

mysql>GRANT SELECT??INSERT??UPDATE??DELETE ON [db_name].* TO [username]@[ipadd] identified by ??[password]??;

[username]:???????????????

[db_name]:??????????????????????

[password]:????????????????

[ipadd]:IP???????IP??????DNS Name??????????????????60-248-32-13.HINET-IP.hinet.net?? ????????????(??)

(???????????????????У??????д??????????ip?????)

???????????????????????У?

mysql>update user set select_priv=??Y?? ?? Insert_priv=??Y???? Update_priv=??Y???? delete_priv=??Y???? Create_priv=??Y???? Drop_priv=??Y????Reload_priv=??Y???? shutdown_priv=??Y???? Process_priv=??Y???? File_priv=??Y???? Grant_priv=??Y???? references_priv=??Y????Index_priv=??Y???? Alter_priv=??Y???? Show_db_priv=??Y???? Super_priv=??Y????Create_tmp_table_priv=??Y????Lock_tables_priv=??Y???? Execute_priv=??Y????Repl_slave_priv=??Y????Repl_client_priv=??Y?? where user=??[username]??;

????????

??ν?????????????????????(mysql) ??xxx.xxx.xxx.xxx is not allowed to connect to this mysql serv

1??????mysql??????????????xuys??

?????grant ??? on ???????.???? ???@??????? identified by "???????";

grant select??update??insert??delete on *.* to xuys@192.168.88.234 identified by "xuys1234";

?????????У?

use mysql;

select host??user??password from user;

?????????user???????и???????xuys?????host??α??????????????????????IP???????????????

??host??ε?????%??????κο?????????????xuys????????mysql?????????????????????%??

3??./mysqld_safe --user-root &

??????????????κ????????????reload??????е?3????

???????????3?????軹????????????????????????2???????mysql??????db???в???????????

use mysql;

insert into db values(??192.168.88.234??????%??????xuys??????Y??????Y??????Y??????Y??????Y??????Y??????Y??????Y??????Y??????Y??????Y??????Y??);

update db set host = ??%?? where user = ??xuys??;

????????????2??3????

????????

????fbysss???phpMyAdmin?????????????????

1.??root?????????Mysql??????

grant select??update??insert??delete on *.* to sss@192.168.0.114 identified by "sss";

update user set host = ??%?? where user = ??sss??;

???mysql????shell?????

#mysqladmin -u root -p [password] reload

#mysqladmin -u root -p [password] shutdown

#/etc/rc.d/init.d/mysqld start

2.???phpMyAdmin???μ?config.inc.php????????

$cfg[??Servers??][$i][??host??] ???????????????

$cfg[??Servers??][$i][??user??] ????sss

$cfg[??Servers??][$i][??password??]????sss??????

????????grant all privilege????????grant?? ?????????????????????????????mysql?????use mysql;update user set Grant_priv =??Y?????????