安装mysql 和hive

1.下载mysql
  wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'
2.安装mysql
  rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
  yum install -y mysql-community-server
3.设置免密登录mysql
  vim /etc/my.cnf
  skip-grant-tables=1
  systemctl restart mysqld
4.修改mysql登录密码
  mysql -uroot
  use mysql;
  update user set password=password("123456") where user="root";
  update user set authentication_string = password('123456'),password_last_changed=now() where user='root';
  flush privileges;
  vim /etc/my.cnf
  去掉原来设置的免密

  mysql -root -p
  use mysql
  set global validate_password_policy=0;
  set global validate_password_length=6;
  set names utf8;
  alter user 'root'@'localhost' identified by '123456';
  exit;
  system restart mysqld

5.远程登录授权
  mysql -u root -p
  use mysql;
  select user host from user;
  GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456"; //若查询没有root授权

6.mysql开机启动
  sysctl enable mysqld
  sysctl daemon-reload

7.安装hive
  cp apache-hive-1.2.2-bin.tar.gz /usr/local/src
  tar -zxvf apache-hive-1.2.2-bin.tar.gz
  cd apache-hive-1.2.2-bin/conf
  mv hive-env.sh.template hive-env.sh
  vim hive.site.xml
  插入默认配置修改mysql密码
  vim hive-env.sh
  export HADOOP_HOME=/usr/local/src/hadoop-2.6.5
  export HIVE_CONF_DIR=/usr/local/src/apache-hive-1.2.2-bin/conf
  export HIVE_AUX_JARS_PATH=/usr/local/src/apache-hive-1.2.2-bin/lib
 
  添加jar包
  tar -xzvf mysql-connector-java-5.1.46.tar.gz
  cd mysql-connector-java-5.1.46
  mv mysql-connector-java-5.1.46.jar /usr/local/src/apache-hive-1.2.2-bin/lib
 
  替换hadoop yarn里jline jar包
  cd /usr/local/src/apache-hive-1.2.2-bin/lib
  cp jline-2.12.jar /usr/local/src/hadoop-2.6.5/share/hadoop/yarn/lib
  cd /usr/local/src/hadoop-2.6.5/share/hadoop/yarn/lib
  rm -rf jline-0.9.94.jar

  设置环境变量
  vim ～/.bashrc
  export HIVE_HOME=/usr/local/src/apache-hive-1.2.2-bin
  export PATH=$PATH:$HIVE_HOME/bin
  source ～/.bashrc

  将配置好的hive和环境变量拷贝到slave相应目录
  先启动hadoop，再启动hive