linux部署mysql

1.下载mysql的安装包

https://downloads.mysql.com/archives/community

2.将安装包上传到集群对应的mysql目录并解压

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

3.卸载自带的Mysql-libs（如果之前安装过MySQL，要全都卸载掉）

rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps

4.安装MySQL依赖

sudo rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm

5.安装mysql-server

sudo rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm

6.安装mysql-client

sudo rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

7.启动MySQL

sudo systemctl start mysqld

8.查看MySQL密码

sudo cat /var/log/mysqld.log | grep password

MySQL配置

配置只要是root用户 + 密码，在任何主机上都能登录MySQL数据库。

1）用刚刚查到的密码进入MySQL（如果报错，给密码加单引号）

[atguigu@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）进入MySQL库

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;