1,Mysql 安装
yum install mysql mysql-server mysql-devel -y
yum install mysql-connector-java
2,启动
service mysqld start
3,修改root密码
mysql -u root
use mysql;
update user set password = password('welcome1') where user = 'root';
flush privileges;
4,创建用户
mysql -u root -pwelcome1
use mysql;
delete from user where user ='';
create user 'hive' identified by 'welcome1';
grant all on *.* TO 'hive'@'%' with grant option;
flush privileges;
5,创建数据库
mysql -uhive -phive
create database hive_metastore2 DEFAULT CHARACTER SET utf8;