#!/bin/bash

# https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar
MYSQL_TGZ="mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar"
MYSQL_URL_DOWNLOAD="https://dev.mysql.com/get/Downloads/MySQL-5.6/${MYSQL_TGZ}"

DEBIAN_FRONTEND=noninteractive

sudo apt-get -y update
sudo apt-get install -y wget > /dev/null 2>&1
sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/root-pass password admin'
sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/re-root-pass password admin'

#sudo apt-get install -y mysql-server > /dev/null 2>&1
#sudo wget -O /tmp/${MYSQL_TGZ} ${MYSQL_URL_DOWNLOAD}
sudo mkdir /tmp/mysql
sudo tar xf /tmp/${MYSQL_TGZ} -C /tmp/mysql
sudo dpkg -i /tmp/mysql/*.deb
sudo apt-get install -fy
sudo rm -rf /tmp/mysql
sudo rm -f /tmp/${MYSQL_TGZ}

#sudo sed -i.bak "s|127.0.0.1|0.0.0.0|g" /etc/mysql/mysql.conf.d/mysqld.cnf
sudo mysql -u root --password=admin mysql < /tmp/addroot.sql
sudo systemctl restart mysql.service
sudo locale-gen es_ES
echo "setxkbmap -layout 'es,es' -model pc105" >> /home/vagrant/.bashrc