derby 转mysql_Hive的元数据库从derby迁移到MySQL

Hive的元数据库从derby到MySQL

1.安装hive

​ (1)解压tar包

​ (2)修改hive-env.sh

​ 修改HADOOP_HOME和

​ HIVE_CONF_DIR

2.替换默認derby数据库为mysql

​ (1)先查询卸载原有的mysql数据库

​ rpm -qa|grep mysql

​ sudo rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64

​ (2)安装server(记得用sudo)

​ 解压unzip mysql-libs.zip

​ 安装mysql服务端：sudo rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm

​ 查询mysql的运行状态：sudo service mysql status

​ 启动mysql的服务端：sudo service mysql start

​ (3)安装clinet(修改密码)：

​ sudo rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm

​ 登陆mysql修改密码：mysql -uroot -p密码

​ 修改mysql的密码：set password = password(‘000000’);

​ (4)修改mysql的权限

​ 修改mysql数据库下的user表

​ update user set host=’%’ where host=‘localhost’;

​ delete from user where Host=‘shufang101’;

​ delete f