Installs parts required for Wordpress install and sets up the database

wpdbinstall.sh

echo -e '\E[1;33;44m' "Install php mysql and apache services"; tput sgr0
parts install php5 php5-apache2 php5-pdo-mysql php5-zlib mysql

echo -e '\E[1;33;44m' "Start the apache and mysql services"; tput sgr0
parts start apache2 mysql

echo -e '\E[1;33;44m' "Create the MySQL database that WP will use"; tput sgr0
# This script uses the default password 'password' - IT IS NOT SECURE!
echo "CREATE DATABASE wordpress;" > msqlcmds.txt
echo "USE wordpress;" >> msqlcmds.txt
echo "CREATE USER wordpressuser@localhost;" >> msqlcmds.txt
# note escaped quotes on line below
echo "SET PASSWORD FOR wordpressuser@localhost= PASSWORD(\"password\");" >> msqlcmds.txt
########################                  wordpressuser    ########

echo "GRANT ALL PRIVILEGES ON wordpress.* TO wordpressuser@localhost IDENTIFIED BY 'password';" >> msqlcmds.txt
########################                                         wordpressuser      ########
echo "FLUSH PRIVILEGES;" >> msqlcmds.txt
echo "exit" >> msqlcmds.txt

echo The password for the MySQL server is blank!
echo You should change it after instalation.
echo - 
echo For now - Just press the enter key to enter the blank password
mysql -u root -p < msqlcmds.txt -v