????1????????
?????????mysql????????????A?????????????B????????????????????A????????????????????????A????????B????mysql?????
????1.1 ???????A?????mysql?????????????A??mysql???????root??
????mysql -u root -p
?????????????????
????1.2 ????????B?????????????
????mysql> grant usage on *.* to username@192.168.0.1 identified by 'password';
?????????????username@192.168.0.1 ???????????????????????192.168.0.1?????username???????????????password
????mysql> grant usage on *.* to username identified by 'password';
?????????????username????????????????????????????????username???????????????password
????mysql> grant all privileges on newdb.* to username@192.168.0.1;
?????????????username@192.168.0.1 ?????????newdb?????????????192.168.0.1?????username??????????????
??????????
????mysql> grant all privileges on *.* to root@192.168.0.1 identified by '123456' ;
?????????????root@192.168.0.1 ???????????????????????192.168.0.1?????root???????????????123456
????2????????
????mysql> drop user root@192.168.0.1;
???????????????root????????????192.168.0.1??????????root?????????????A????????