???????mysql?????????????????????????????????1130??ERROR 1130: Host 192.168.0.10 is not allowed to connect to this MySQL server ?????????????????2????????
????1?????????????????mysql??????“mysql”????????“user”?????“host”????”localhost”???'%'??
mysql>
mysql>use mysql;
mysql>select 'host' from user where user='root';        #??mysql???е?user???host??????????????????????/IP?????
mysql>update user set host = '%' where user ='root'; #???host?????????%??????????????/IP??????????????????????????IP???????????update????????ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' ???????select host from user where user = 'root';
?????????host??????????%????????????????????????flush privileges;?????
mysql>flush privileges;
mysql>select host??user from user where user='root';
mysql>quit
????????????DOS????????????????????????????????Mysql???
????========================================
????2. ??????????磬????myuser???mypassword???κ??????????mysql???????????
?????mysql???????????????????
????grant all privileges on *.* to remoteuser@remoteIPAddr identified by 'password'; (remoteIPAddr??????????ip)
???????磺grant all privileges on *.* to myuser@192.168.0.10 identified by 'shihuan';
????GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
??????????????????myuser??ip?192.168.0.10???????????mysql?????????????mypassword???????
????GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.0.10' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
???????mysql.user??root?????host?????localhost???????????localhost???“??”????????У??????1130????????“???κ??????????mysql??????”?????????????????????????????ip?????????????????