circleci mysql upgrade

mysql.sh

#!/bin/bash
set -x
set -e

export DEBIAN_FRONTEND=noninteractive

sudo apt-get --purge autoremove -y mysql-server-5.6

sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 8C718D3B5072E1F5

curl -LO https://dev.mysql.com/get/mysql-apt-config_0.8.14-1_all.deb

echo mysql-apt-config mysql-apt-config/select-product          select Apply              | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-server           select mysql-8.0          | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-connector-python select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-workbench        select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-utilities        select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-connector-odbc   select connector-odbc-x.x | sudo debconf-set-selections

sudo -E dpkg -i mysql-apt-config_0.8.14-1_all.deb
sudo apt-get update && sudo apt-get -f -y upgrade
echo mysql-community-server mysql-community-server/re-root-pass password password | sudo debconf-set-selections
echo mysql-community-server mysql-community-server/root-pass password password | sudo debconf-set-selections
#sudo RUNLEVEL=1 -E apt-get -y install mysql-community-server
sudo apt-get -f -y install mysql-server mysql-client default-mysql-client

echo "Checking installed version....."
mysql -V

# https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/
echo 'sql-mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"' | sudo tee -a /etc/mysql/my.cnf
sudo service mysql restart

echo "Checking sql_mode....."
mysql -u root -ppassword -e "show variables like 'sql_mode'"
echo "Done!!"