mysql56-install-basic.sh

#!/bin/bash
apt-get install -y software-properties-common
debconf-set-selections <<< "mysql-server-5.6 mysql-server/root_password password PASS"
debconf-set-selections <<< "mysql-server-5.6 mysql-server/root_password_again password PASS"
wget -O "/etc/apt/sources.list.d/mysql.list" http://ad-cameron.aegisdoctrine.local/mysql.list
#add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
apt-get update
apt install -y mysql-server-5.6 mysql-client-5.6 libmysql-java
service mysql start

mysql -uroot -pPASS -e "SET PASSWORD = PASSWORD('');"
mysql -u root -e "
CREATE USER 'hadoop'@'%' IDENTIFIED BY 'hadoop12345';
GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'%';
FLUSH PRIVILEGES;

CREATE DATABASE ambari;
CREATE DATABASE hive;
CREATE DATABASE oozie;
"

#clinet only
#sudo apt-get install -y software-properties-common
#sudo add-apt-repository 'deb http://archive.ubuntu.com/ubuntu trusty universe'
#sudo apt-get update
#sudo apt install -y mysql-client-5.6 libmysql-java