cdh

    xiaoxiao2026-06-14  12

    1、安装mysql  sudo yum install mysql-server

    2、查看mysql的运行状态

      sudo service mysqld status 

    3、开机启动   sudo chkconfig mysqld on    sudo chkconfig --list mysqld

    4、连接mysql

            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';

    转载请注明原文地址: https://ju.6miu.com/read-1310514.html
    最新回复(0)