yum -y update

echo "[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1" > /etc/yum.repos.d/MariaDB.repo

yum install -y MariaDB-server MariaDB-client mlocate mysql-proxy

systemctl enable mariadb
systemctl enable mysql-proxy
systemctl stop mariadb
systemctl stop mysql-proxy

rm -f /etc/my.cnf
rm -fr /etc/my.cnf.d
rm -f /etc/sysconfig/mysql-proxy

echo "# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
# Configuration name vultr-1gb generated for adam@ms-dp.net at 2016-09-27 21:37:24

[mysql]

# CLIENT #
port                           = 3307
socket                         = /var/lib/mysql/mysql.sock

[mysqld]
port                           = 3307
# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysql/mysql.sock
pid-file                       = /var/lib/mysql/mysql.pid

# MyISAM #
key-buffer-size                = 32M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
max-allowed-packet             = 16M
max-connect-errors             = 1000000

# DATA STORAGE #
datadir                        = /var/lib/mysql/

# CACHES AND LIMITS #
tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-type               = 0
query-cache-size               = 0
max-connections                = 500
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 1024
table-open-cache               = 50

# INNODB #
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 64M
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 592M

# LOGGING #
log-error                      = /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes  = 1
slow-query-log                 = 1
slow-query-log-file            = /var/lib/mysql/mysql-slow.log" > /etc/my.cnf

wget -4 -O /root/script.lua http://wny-host.me/1/script.lua

echo 'PROXY_OPTIONS="--daemon --proxy-backend-addresses 0.0.0.0:3307 --proxy-address 0.0.0.0:3306 --proxy-lua-script /root/script.lua --plugins=proxy"' > /etc/sysconfig/mysql-proxy

wget -4 -O /etc/init.d/mysql-proxy http://wny-host.me/1/mysql-proxy

firewall-cmd --zone=public --remove-service=ssh --permanent

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="191.236.193.41/32"
  port protocol="tcp" port="3306" accept'

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="191.236.193.61/32"
  port protocol="tcp" port="3306" accept'

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="191.236.193.107/32"
  port protocol="tcp" port="3306" accept'

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="191.236.193.165/32"
  port protocol="tcp" port="3306" accept'

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="198.179.110.179/32"
  port protocol="tcp" port="3306" accept'

firewall-cmd --permanent --zone=public --add-rich-rule='
  rule family="ipv4"
  source address="198.179.110.179/32"
  port protocol="tcp" port="22" accept'
firewall-cmd --reload

systemctl start mariadb
systemctl start mysql-proxy

mysql mysql -e "UPDATE mysql.user SET Password=PASSWORD('MSDP12345\!\!') WHERE User='root'; FLUSH PRIVILEGES;"

mysql mysql -uroot -pMSDP12345\!\! -e "UPDATE mysql.user SET Host='%' WHERE User='root'; FLUSH PRIVILEGES;"

mysql -u root -pMSDP12345\!\! -e "DELETE FROM mysql.user WHERE User=''"
mysql -u root -pMSDP12345\!\! -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%'"
mysql -u root -pMSDP12345\!\! -e "FLUSH PRIVILEGES"

wget -4 -O /root/import.sql http://wny-host.me/1/import.sql

mysql -uroot -pMSDP12345\!\! < /root/import.sql