????????????ip??192.168.1.100
???????????ip??192.168.1.244
????????????? mysql ????????#/etc/init.d/mysql.server start
??????????????????? mysql????????./mysql -h "192.168.1.244" -u root -p
???????????′???
????ERROR 1130 (HY000): Host '192.168.1.100' is not allowed to connect to this MySQL server

????????????????????mysql??????????????????????????????????????????
?????????????
????1?????????(ip:192.168.1.244)??????￡?
???????????????/etc/init.d/mysql.server start
???????????????bin/mysql -u root -p
??????÷???????mysql> use mysql
????????????????????? :
????mysql> grant all PRIVILEGES on test.* to andy@'192.168.1.100' identified by '123456';
???????????????? test ?????????????????? andy ???????????? andy ????? 192.168.1.100??? IP ????????????????? andy ?????????? 123456 ??
??????????????????е??????
????all PRIVILEGES ??????????е???????????????????????滻???????????????????磺select??insert??update??delete??create??drop ?????????????“??”?????????
????test.* ?????????????????????????test ??????????????? * ??????????е??????????????????????????????????????“*.*”???????????????????????“???????.*”??????????????????????“???????.????”??
????andy ??????????????????????????????????????????????????????????
????192.168.1.100 ??????????????? IP ??????????????????? IP ???????“%”???ɡ?
????123456 ??????????
?????????????????????????????????????????Ч??
????> flush privileges;
????2??????????(ip:192.168.1.100)??
??????????￡?./mysql -h 192.168.1.244 -u andy -p 123456
??????????￡?