#!/bin/sh
# Configure
# prepare
touch .my.cnf.$$ .mysql.$$
chmod 600 .my.cnf.$$ .mysql.$$

# find_mysql_client

# Prepare credentials
echo "[mysql]" > .my.cnf.$$
echo "user=root" >> .my.cnf.$$
echo "password='basic_single_escape \"\"'" >> .my.cnf.$$ 

# set_echo_compat
# get_root_password
# set_root_password
echo "UPDATE mysql.user SET Password=PASSWORD('basic_single_escape \"qqqqqq\"') WHERE User='root';" > .mysql.$$
mysql --defaults-file=.mysql.$$ < .mysql.$$

# reoload_privilege_tables
echo "FLUSH PRIVILEGES;" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

# make_config
echo "[mysql]" > .my.cnf.$$
echo "user=root" >> .my.cnf.$$
echo "password='basic_single_escape \"qqqqqq\"'" >> .my.cnf.$$ 

# remove_anonymous_users
echo "DELETE FROM mysql.user WHERE User='';" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

# remove_remote_root
echo "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

# remove_test_database
echo "DROP DATABASE test;" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

echo "DELETE FROM mysql.db WHERE Db='test' or Db='test\\_%';" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

# reoload_privilege_tables
echo "FLUSH PRIVILEGES;" > .mysql.$$
mysql --defaults-file=.my.cnf.$$ < .mysql.$$

# cleanup
rm -f .my.cnf.$$ .mysql.$$