1.创建数据库
CREATE DATABASE hive_metadata;
2.创建用户
CREATE USER 'hive'@'%' IDENTIFIED BY '123456';
3.将数据库所有权限给到指定用户
GRANT ALL PRIVILEGES on hive_metadata.* TO 'hive'@'%';
4.查看Mysql是否开启binlog,及binlog模式
SHOW VARIABLES LIKE 'log_bin';
show global variables like "binlog%";
5.查看使用root远程登录
alter user 'root'@'%' identified with mysql_native_password by '123456';