MySql 5.7 installed on Ubuntu Trusty

[msvrtan]

What is root password there?

[ssexton]

We’re having this problem too. All of our tests are failing as of one day ago because it looks like the root mysql user now requires a password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

As part of our build process, we execute the SQL from mysql_tzinfo_to_sql /usr/share/zoneinfo as the root user to populate the timezone data for the database, but this is no longer possible because root can’t log in.

1. Why is there no warning or notice of this change on https://circleci.com/changelog/ ?
2. How do I set the root password for mysql on the Circle instance so my tests can run again?

[ssexton]

So it turns out they’ve changed the root username from root to ubuntu. Try using that instead and you should be good.

[drazisil]

That sounds about right. Thank you so much for sharing!

[tom]

Please see:

Error installing MySQL 5.6

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 features subject to breaking changes from MySQL 5.6 to 5.7). So our recommendation is to run with the preinstalled 5.7 and only revert to 5.6 if your database is incompatible with 5.7.