MySQL??????????????????
???????????? ???????[ 2014/11/11 13:21:36 ] ????????????? MySQL
????????з???????????
???????μ???????????????MySQL ????????????????????????????????????MySQL ??????????????????????貢???????????????????????????????????MySQL ???????????????????????????
????1??d:MySQLin>MySQL -h localhost -u root
?????????????????MySQL??????
??????????????????:
????MySQL>update user set host = '%' where user = 'root';
????MySQL>select host?? user from user;
????2??MySQL>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION
???????κ?????????????????
????3??MySQL>FLUSH PRIVILEGES
?????????Ч
????4??MySQL>EXIT
???????MySQL??????
???????????????????κε?????????root?????????
???????????????????MySQL ????????????????????????????????
????????????:
????1??????????? mysql -u root -p mysql????????????????root?????????????????????mysql???????????????????mysql??????????????mysql?????????????????????
????2????mysql???????? GRANT ALL PRIVILEGES ON *.* TO ‘root'@'%' IDENTIFIED BY ‘MyPassword' WITH GRANT OPTION;
????3????mysql?????????????е? ‘root'@'%' ???????????: root?????????%??????????IP??????????%??????????????IP???????????滻??????????????????????IP?????'MyPassword'??????????????????????????????????????????????????????????????????????????????GRANT??????????????http://dev.mysql.com/doc/refman/5.1/en/grant.html
????4????????????????mysql???????? select host?? user from user; ???????????????????
??????
???·???
??????????????????
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