MySQL 5.6 in CircleCI

circle.yml

dependencies:
  post:
    - export DEBIAN_FRONTEND=noninteractive
    - sudo apt-get -y remove mysql-server
    - sudo apt-get -y autoremove
    - sudo apt-get -y install software-properties-common
    - sudo add-apt-repository -y ppa:ondrej/mysql-5.6
    - sudo apt-get update
    - sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password ""'
    - sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password ""'
    - sudo apt-get -y install mysql-server

I've asked their support. They don't have a way.

Hi there,

The code above didn't work because apt would get a bunch of 404 errors.
This worked for me:

machine:
  pre:
    # Install MySQL 5.6 (5.5 is installed by default)
    - >
      export DEBIAN_FRONTEND=noninteractive
      && sudo apt-get update -y; true
      && sudo apt-get -y remove mysql-server
      && sudo apt-get -y autoremove
      && sudo apt-get -y install software-properties-common
      && sudo apt-add-repository -y 'deb http://ppa.launchpad.net/ondrej/mysql-experimental/ubuntu precise main'
      && sudo apt-get update -y; true
      && sudo apt-get -y install mysql-server
      && sudo chown -R mysql:mysql /var/lib/mysql

Hi all,

I took the code from @eexit and change a couple of lines because it wasn't working on my builds, here is my successful attempt, hope it helps.

machine:
    pre:
    - sudo apt-get update -y; true
    - sudo apt-get -y remove mysql-server
    - sudo apt-get -y install software-properties-common
    - sudo apt-add-repository -y 'deb http://ppa.launchpad.net/ondrej/mysql-experimental/ubuntu precise main'
    - sudo apt-get update -y; true
    - export DEBIAN_FRONTEND=noninteractive && sudo -E apt-get -y install mysql-server
    - sudo chown -R mysql:mysql /var/lib/mysql