mysql5.5 升级到 5.7 的坑

1.大概思路,docker 新启一个mysql5.7 端口映射到3307

2. 导出5.5 的.sql文件,导入5.7中

3.测试通过后,可将5.5关闭。5.7端口改回3306

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "**";

坑记录:

1.在[mysqld] 下面加上sql_mode=

2.max_allowed_packet=16M

链接

一个外键的错误,记不清了

https://blog.csdn.net/SmallYard/article/details/73593853

 

[Err] 2006 - MySQL server has gone away

https://blog.csdn.net/defonds/article/details/45129953

posted @ 2018-07-30 15:10 丨Mars 阅读(...) 评论(...) 编辑 收藏