Mysql on Ubuntu setup (CM)
# install mysql
cd ~/cdh-preinstall
apt-get install mysql-server mysql-client libmysql-java -y
# stop and copy in new my.cnf
sudo service mysql stop
sudo cp files/my.cnf.ubuntu /etc/mysql/my.cnf
# restart mysql and secure
sudo mysql start
sudo /usr/bin/mysql_secure_installation
# setup cm database
/usr/share/cmf/schema/scm_prepare_database.sh -u root -p mysql cm cm cm
Enter database password:
Verifying that we can write to /etc/cloudera-scm-server
Creating SCM configuration file in /etc/cloudera-scm-server
Executing: /usr/lib/jvm/java-7-oracle-cloudera/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
[ main] DbCommandExecutor INFO Successfully connected to database.
All done, your SCM database is configured correctly!
# create additional users
mysql -u root -p
.\ 13_install_mysql_users.sh