Install MySQL 5.7 on Travis-CI

.travis.install-mysql-5.7.sh

sudo apt-get remove --purge "^mysql.*"
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm -rf /var/lib/mysql
sudo rm -rf /var/log/mysql
echo mysql-apt-config mysql-apt-config/enable-repo select mysql-5.7-dmr | sudo debconf-set-selections
wget http://dev.mysql.com/get/mysql-apt-config_0.2.1-1ubuntu12.04_all.deb
sudo dpkg --install mysql-apt-config_0.2.1-1ubuntu12.04_all.deb
sudo apt-get update -q
sudo apt-get install -q -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" mysql-server

.travis.yml

before_script:
  - bash .travis.install-mysql-5.7.sh

Note: this currently removes hhvm, which likely has dependencies on a mysql* package. I did not yet find a way to make this work without fully uninstalling MySQL 5.5 first.

I can't connect to mysql using your method : Access denied for user 'root'@'localhost'.
Do you have an idea ?

Here is my way of improving this method and making it work for my project : http://stackoverflow.com/questions/34831695/configure-mysql-5-7-with-travis-ci

+1 `Access denied for user 'root'@'localhost'

+1 `Access denied for user 'root'@'localhost'

As of today it's just select mysql-5.7 not select mysql-5.7-dmr.

As for access denied it seems 5.7 uses a temporary root password:
https://www.percona.com/blog/2016/05/18/where-is-the-mysql-5-7-root-password/

I did not have a password issue with the dmr build but I do with the latest.

As mentioned by @gcphost this is broken because mysql-5.7-dmr no longer exists. Here is my modified and working install script for travis that installs the official 5.7.

Sorry for not reacting to your comments, they still don't trigger notifications to date.
@codyzu's install script is the way to go right now!

@codyzu can you verify? I cannot seems to get it to work on xenial (Ubuntu 16.06)

I could not get @Codyzy's script to work on Trusty (14.04) either, but passing the non-interactive flag directly to dpkg worked flawlessly with the newer mysql-apt-config:

sudo DEBIAN_FRONTEND=noninteractive dpkg -i mysql-apt-config_0.8.1-1_all.deb

In .travis file you need to add sudo: required so the sudos in the script can be run.

@asimzeeshan Try to change the mysql-5.7-dmr to mysql-5.7