The builds installing MySQL 5.6 from the ondrej/mysql-5.6 PPA on Launchpad have recently started failing, as the PPA doesn’t contain the track for our container OS (Ubuntu 12.04LTS Precise) anymore.
The ondrej/mysql-experimental PPA still contains the mysql-5.6 package for Precise, so you can change the add-apt-repository command in your circle.yml to the following to make the builds work again:
I had the same issue after downgrading. It looks like the MySQL username “root” with no password works. I just updated all my CI database configs to use that. We’ll see how this build goes, but it at least appears to be connecting to the DB now.
Running bundler with sudo leads to a lot of access issues. sudo bundle exec rake db:create:all db:schema:load --trace Your Ruby version is 1.9.3, but your Gemfile specified 2.2.4
We’re also experience the same issue. Was this issue not foreseen before upgrading the MySQL versions from 5.6 to 5.7?? I feel as if a solid solution must’ve been thought of before the upgrade because now we can’t get any of our builds and deployment to work!
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.
@tom - Does this mean that if we require mysql-server-5.6, we are still stuck with the Access denied for user 'ubuntu'@'localhost' (using password: NO). problem?
Is there a solution from CircleCI to successfully run mysql-server-5.6 package? That was the whole point. The builds started breaking against a previously documented and supported approach to 5.6 installation.
@tom Could you provide us with a clear solution to using MySQL 5.6? I’m also having the same issue as @sainejob–
**Access denied for user ‘ubuntu’@‘localhost’ (using password: NO). ** Please provide the root password for your mysql installation
How can we change the user ubuntu or inject the root password (which I believe is a blank string?). This has been a very frustrating experience because it has completely blocked our builds/deployment and we’re currently forced to completely bypass CircleCI because of this issue and the lack of solution provided by CircleCI…
@tom - Thanks! That fixes it. I tried to go down this path but didn’t quite have enough information regarding the CircleCI MySQL setup. You should also update the CircleCI FAQ regarding mysql-server-5.6 (here: https://circleci.com/docs/faq/#how-do-i-use-mysql-56) so that others will get the update. This page comes up pretty high in Google when searching for answers on this topic.
@tom I’m using the Ubuntu 14.04 build image and didn’t need to use the PPA, there’s mysql-server-5.6 in the regular packages for Ubuntu 14.04, for the rest, this solved my issue!