04_mysql-community-client-5.7.29-1.el7.x86_64.rpm
05_mysql-community-server-5.7.29-1.el7.x86_64.rpm
mysql-connector-java-5.1.48.jar
2.2.2
安装
MySql
1
）安装
mysql
依赖
[lxx@hadoop102 software]$ sudo rpm -ivh 01_mysql-community-common-5.7.29-1.el7.x86_64.rpm
[lxx@hadoop102 software]$ sudo rpm -ivh 02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm
[lxx@hadoop102 software]$ sudo rpm -ivh 03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm
2
）安装
mysql-client
[lxx@hadoop102 software]$ sudo rpm -ivh 04_mysql-community-client-5.7.29-1.el7.x86_64.rpm
3
）安装
mysql-server
[lxx@hadoop102 software]$ sudo rpm -ivh 05_mysql-community-server-5.7.29-1.el7.x86_64.rpm
4
）启动
mysql
[lxx@hadoop102 software]$ sudo systemctl start mysqld
5
）查看
mysql
密码
[lxx@hadoop102 software]$ sudo cat /var/log/mysqld.log | grep password
2.2.3
配置
MySql
配置只要是
&
用户
D
密码，在任何主机上都能登录
3
数据库。
1
）用刚刚查到的密码进入
mysql
（如果报错，给密码加单引号）
[lxx@hadoop102 software]$ mysql -uroot -p’password’
2
）设置复杂密码
(
由于
mysql
密码策略，此密码必须足够复杂
)
mysql> set password=password("Qs23=zs32");
3
）更改
mysql
密码策略
mysql> set global validate_password_length=4;
mysql> set global validate_password_policy=0;
4
）设置简单好记的密码
mysql> set password=password("000000");
5
）进入
msyql
库
mysql> use mysql
6
）查询
user
表
mysql> select user, host from user;
7
）修改
user
表，把
Host
表内容修改为
%
mysql> update user set host="%" where user="root";
8
）刷新
mysql> flush privileges;
9
）退出
mysql> quit;
2.3
Hive
安装部署
1
）把
apache-hive-3.1.2-bin.tar.gz
上传到
linux
的
/opt/so"ware
目录下
评论0