#!/bin/bash
echo -e "Please provide a desired password for Mysql root account? : \c "
read MYSQLROOTPASS
echo "mysql-server mysql-server/root_password password $MYSQLROOTPASS" | debconf-set-selections
echo "mysql-server mysql-server/root_password_again password $MYSQLROOTPASS" | debconf-set-selections
echo "phpmyadmin phpmyadmin/dbconfig-install boolean true" | debconf-set-selections
echo "phpmyadmin phpmyadmin/app-password-confirm password $MYSQLROOTPASS" | debconf-set-selections
echo "phpmyadmin phpmyadmin/mysql/admin-pass password $MYSQLROOTPASS" | debconf-set-selections
echo "phpmyadmin phpmyadmin/mysql/app-pass password $MYSQLROOTPASS" | debconf-set-selections
echo "phpmyadmin phpmyadmin/reconfigure-webserver multiselect apache2" | debconf-set-selections
apt-get -y install mysql-server python-mysqldb phpmyadmin mytop
sed -i 's|query_cache_size        = 16M|query_cache_size = 1M|' /etc/mysql/my.cnf
sed -i 's|key_buffer              = 16M|key_buffer = 1M|' /etc/mysql/my.cnf
sed -i 's|max_allowed_packet      = 16M|max_allowed_packet = 1M|' /etc/mysql/my.cnf
/etc/init.d/mysql restart
mysqladmin -u root --password="$MYSQLROOTPASS" create sahana