参考:
https://www.cnblogs.com/fnlingnzb-learner/p/5830622.html
https://www.cnblogs.com/duanrantao/p/8988116.html
机器A的ip地址为ipa,mysql数据库装在机器B上,若想A可以访问mysql需要:
进入机器B中mysql数据库的命令行,执行:
grant all on *.* to 'root'@'ipa' identified by 'password';
即可,password为mysql密码