1.安装mysql
yum -y install mariadb-server
启动mysql
service mariadb start
删除匿名用户
delete from mysql.user where user=’’;
root用户设定密码
SET PASSWORD = PASSWORD(‘123456’);
SET PASSWORD for ‘root’@‘127.0.0.1’ = PASSWORD(‘123456’);
SET PASSWORD for ‘root’@‘localhost’ = PASSWORD(‘123456’);
SET PASSWORD for ‘root’@’::1’ = PASSWORD(‘123456’);
SET PASSWORD for ‘root’@‘server11’ = PASSWORD(‘123456’);
重启mysql生效
service mariadb restart
建立用户
create user “hive”@"%" identified by “123456”;
建立数据库
create database hive DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
授权
grant all privileges on hive.* to ‘hive’@’%’ IDENTIFIED BY ‘123456’;