#!/bin/bash

# https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz 
MYSQL_FOLDER="mysql-5.5.62-linux-glibc2.12-x86_64"
MYSQL_TGZ="${MYSQL_FOLDER}.tar.gz"
MYSQL_URL_DOWNLOAD="https://dev.mysql.com/get/Downloads/MySQL-5.5/${MYSQL_TGZ}"
MYSQL_HOME="/usr/local/mysql"

DEBIAN_FRONTEND=noninteractive

sudo apt-get -y update
sudo apt-get install -y wget libaio1 > /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 wget -O /tmp/${MYSQL_TGZ} ${MYSQL_URL_DOWNLOAD}
sudo tar zxf /tmp/${MYSQL_TGZ} -C /tmp/
sudo mv /tmp/${MYSQL_FOLDER} ${MYSQL_HOME}

sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql
sudo chown -R mysql:mysql ${MYSQL_HOME}
cd ${MYSQL_HOME}
sudo ${MYSQL_HOME}/scripts/mysql_install_db --basedir=${MYSQL_HOME} --user=mysql
sudo chown -R root ${MYSQL_HOME}
sudo chown -R mysql ${MYSQL_HOME}/data

sudo cp ${MYSQL_HOME}/support-files/my-medium.cnf /etc/my.cnf
sudo cp ${MYSQL_HOME}/support-files/mysql.server /etc/init.d/mysql.server
sudo mkdir /var/run/mysql
sudo chown -R mysql /var/run/mysql

cd ${MYSQL_HOME}
sudo ${MYSQL_HOME}/bin/mysqld_safe --user=mysql --basedir=${MYSQL_HOME} &

sleep 10
${MYSQL_HOME}/bin/mysqladmin -u root password 'admin'
sudo ${MYSQL_HOME}/bin/mysql -u root --password=admin mysql < /tmp/addroot.sql
sudo update-rc.d mysql.server defaults
#sudo systemctl restart mysql.service

sudo locale-gen es_ES
echo "setxkbmap -layout 'es,es' -model pc105" >> /home/vagrant/.bashrc
sudo echo "PATH=\"${PATH}:${MYSQL_HOME}/bin\"" >> /etc/environment