Error installing MySQL 5.6

Build Environment Databases
, ,
7

To downgrade from MySQL 5.7 to 5.6 on 14.04 you can add the following to circle.yml:

dependencies:
  pre:
    - >
      sudo DEBIAN_FRONTEND=noninteractive apt-get remove --yes --purge mysql* &&
      sudo apt-get autoremove &&
      sudo apt-get autoclean &&
      sudo rm -rf /var/lib/mysql &&
      sudo apt-add-repository -y 'deb http://ppa.launchpad.net/ondrej/mysql-experimental/ubuntu precise main' &&
      sudo apt-get update; sudo DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server-5.6
    - echo "CREATE USER '${CIRCLECI_USER}'@'localhost'" | mysql -u root
    - echo "GRANT ALL PRIVILEGES ON *.* TO '${CIRCLECI_USER}'@'localhost' WITH GRANT OPTION" | mysql -u root
    - echo "CREATE USER 'circle'@'localhost'" | mysql -u root
    - echo "GRANT ALL PRIVILEGES ON *.* TO 'circle'@'localhost' WITH GRANT OPTION" | mysql -u root
    - echo "FLUSH PRIVILEGES" | mysql -u root
    - echo "CREATE DATABASE circle_test" | mysql -u root

You may also wish to set environment variables:

machine:
  environment:
    MYSQL_HOST: localhost
    MYSQL_USER: ubuntu
    MYSQL_PASSWORD: ''
    MYSQL_CONNECTION_LIMIT: 30
    MYSQL_PORT: 3306
1 Like