Linux??mysql?????????
???????????? ???????[ 2016/9/2 11:06:24 ] ????????????? MySQL
????????????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
??????????£?
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11