How to downgrade? We didn’t expect the change from 5.6 to 5.7 over this weekend, our app doesnt support 5.7 (incompatible group by issues)

I also had incompatibility problems with 5.7 in an older project. I ended up (ab)using circle’s docker support to install mysql 5.6 on the machine, and then pointed my application to that: machine: services: - docker dependencies: pre: - docker run -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -p 330…

Please see: [image] Error installing MySQL 5.6 Databases Apologies for the breaking change. This was unexpected. We’ve just rolled out an update to the 14.04 image so builds that ran successfully with 5.6 should now run without changes on 5.7 (unless you are using MySQL …

It also broke the build for us. @justinlee46 the incompatible group issue might be solved by this setting? test: pre: - echo "SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));" | mysql

This method works great, but instead what I would recommend doing is removing mysql-community-server from the CircleCI box totally in the dependencies -> pre node and that way you can bind 3306 directly into the container. machine: services: - docker dependencies: pre: - sudo apt-get re…

Downgrading MySQL 5.7 to MySQL 5.6 on Ubuntu Trusty 64

Build Environment

justinlee46 June 27, 2016, 8:42pm 2

Also trying to downgrade to 5.6 because our builds failsfor 5.7. There’s been some responses for the following thread but I don’t think a solid solution has been introduced…

Topic		Replies	Views
Error installing MySQL 5.6 Databases known-issue , mysql , circle-yml	21	10792	January 11, 2017
Installing MySQL 5.7 Build Environment mysql	15	7992	January 27, 2017
MySql 5.7 installed on Ubuntu Trusty Feedback & Bug Reports php , mysql	4	4074	June 28, 2016
How to change MySQL/MariaDB version Databases mysql	3	8479	January 25, 2016
MySql 5.6 Trusty no longer installs Build Environment mysql	3	2538	July 23, 2019

Downgrading MySQL 5.7 to MySQL 5.6 on Ubuntu Trusty 64

Related topics