前言
链 接
提取码:9blz
1. MySQ安装
- 下载MySQL,前言链接有:
# 删除原有mariadb
rpm -qa |grep mariadb |xargs yum remove -y
# 解压
tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar
# 依次安装rpm
rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm
# devel博主安装失败了, 可以继续安装后面的
rpm -ivh mysql-community-devel-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm
# 初始化
chmod -R 777 /var/lib/mysql
mysqld --initialize
# 启动,设置开机启动
systemctl start mysqld.service
systemctl enable mysqld.service
- 查看数据库密码:
- 登录MySQL:
- 重新修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
设置其他用户或远程可登录:
create user 'root'@'%' identified with mysql_native_password by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
参考:https://blog.csdn.net/wangkai_123456/article/details/87603464
不需要创建数据库可忽略
- 创建Hive元数据库
CREATE DATABASE hive DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
- 创建cdh 元数据库
CREATE DATABASE amon DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
- Windows下使用Navicat测试:(填写IP,登陆密码)