MySql 5.7 installed on Ubuntu Trusty

php
mysql

#1

What is root password there?


#2

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?

#3

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


#4

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


#5

Please see:


#6