1.linux环境下安装mysql
参考连接:https://blog.youkuaiyun.com/wohiusdashi/article/details/89358071
2.修改host匹配方式,用于支持远程连接
完成上述操作后,远程连接会报错误:
【1130 - Host XXX is not allowed to connect to this MySQL server】
解决方案:将Host修改为通配符
use mysql;
update user set host = ‘%’ where user =‘root’;
之后刷新下配置:
flush privileges;