mysql -h localhost -u root -p (默认密码为空)
5、修改root密码
sudo /usr/bin/mysql_secure_installation (password:123456)
6、安装jdbc dirver
tar zxvf mysql-connector-java-5.1.31.tar.gz sudo cp mysql-connector-java-5.1.31/mysql-connector-java-5.1.31-bin.jar /usr/share/java/mysql-connector-java.jarsudo mkdir -p /usr/share/java/ (如不存在需要创建) 7、创建db
create database database DEFAULT CHARACTER SET utf8; grant all on database.* TO 'user'@'%' IDENTIFIED BY 'password'; Role Database User Password Activity Monitor amon amon amon_password Reports Manager rman rman rman_password Hive Metastore Server metastore hive hive_password Sentry Server sentry sentry sentry_password Cloudera Navigator Audit Server nav nav nav_password Cloudera Navigator Metadata Server navms navms navms_password
create database amon default character utf8;
grant all on amon.* to 'amon'@'%' identified by 'amon_password';
create database rman default character utf8;
grant all on rman.* to 'rman'@'%' identified by 'rman_password';
8、HUE
create database hue default character utf8;
grant all on hue.* to 'hue'@'%' identified by 'secretpassword';
9、OOZIE
create database OOZIE default character utf8;
grant all on oozie.* to 'oozie'@'%' identified by 'oozie';
