#!/bin/bash -x

BASEURL=https://ukr.pw

export DEBIAN_FRONTEND=noninteractive
echo "deb http://ftp.ddg.lth.se/mariadb/repo/10.5/ubuntu bionic main" >> /etc/apt/sources.list
echo "deb-src http://ftp.ddg.lth.se/mariadb/repo/10.5/ubuntu bionic main" >> /etc/apt/sources.list
apt-get -y install gnupg2
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8
apt-get update
apt-get -y install mariadb-server
service mysql stop
rm -f /etc/mysql/my.cnf
wget -O /etc/mysql/my.cnf $BASEURL/ub/my.cnf.1G.txt
rm -f /var/lib/mysql/ib_log*
service mysql start
if [ ! -x /bin/gp ]; then
   wget -O /bin/gp $BASEURL/gp.txt
   chmod 755 /bin/gp
fi
MSLRTPW=`gp 16`
wget -O - $BASEURL/mysql/setpw.mariadb105.txt | sed -e "s/PWPWPW/$MSLRTPW/" | mysql mysql
echo
echo
echo "MySQL root password is $MSLRTPW"
echo
echo
echo $MSLRTPW > /root/.pass.my