mysql常见问题

去掉 sql_mode 的 ONLY_FULL_GROUP_BY

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

更改MySQL5.7数据库目录位置

https://www.cnblogs.com/phpk/p/10935879.html

mysql5.7的my.cnf配置文件

https://blog.csdn.net/weixin_41043145/article/details/92366815

主从复制：MySQL server UUIDs问题解决

https://blog.csdn.net/mascf/article/details/52904616

Slave_IO_Running: Yes
Slave_SQL_Running: Yes