#!/bin/bash

BASEURL=http://ukr.pw

yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum -y install mysql-community-server mysql-community-libs mysql-community-libs-compat mysql-community-client
wget -O - $BASEURL/mysql/my.cnf.5.6.txt > /etc/my.cnf
QUARTERRAM=`free | grep Mem: | awk '{ print int($2/4096)"M" }'`
sed -i -e "s/pool_size=64M/pool_size=${QUARTERRAM}/" /etc/my.cnf
service mysqld start
if [ ! -x /bin/gp ]; then
   wget -O /bin/gp $BASEURL/gp.txt
   chmod 755 /bin/gp
fi
MSLRTPW=`gp 16`
VERSIONSTRING=`mysql -e "select version()" | egrep -v '(--|vers)'`
MAJORVERSION=`expr substr $VERSIONSTRING 1 3`
if [ $MAJORVERSION = "5.5" -o $MAJORVERSION = "5.6" ]; then
  TAG=56
else
  TAG=57
fi
wget -O - $BASEURL/mysql/setpw.$TAG.txt | sed -e "s/PWPWPW/$MSLRTPW/" | mysql mysql
echo
echo
echo "MySQL root password is $MSLRTPW"
echo
echo
echo $MSLRTPW > /root/.pass.my