MySql安装

一．卸载自带的Mysql-libs（如果之前安装过mysql，要全都卸载掉）

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

二．将安装包和JDBC驱动上传到/opt/software，共计6个

01_mysql-community-common-5.7.29-1.el7.x86_64.rpm
02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm
03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm
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

三.安装MySql

1.安装mysql依赖

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

2.安装mysql-client

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

3.安装mysql-server

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

很简单，如错误信息显示，缺少perl.x86_64三个依赖，使用yum安装即可，重新安装mysql-server。

 yum install -y perl

4.启动mysql

sudo systemctl start mysqld

5.查看mysql密码

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

四.配置MySql

配置成只要是root用户+密码，在任何主机上都能登录MySQL数据库。
1．用刚刚查到的密码进入mysql（如果报错，给密码加单引号）

mysql -h localhost -u root -p

2．设置复杂密码(由于mysql密码策略，此密码必须足够复杂)

set password=password("Qs23=zs32");

3．更改mysql密码策略

set global validate_password_length=4;
set global validate_password_policy=0;

4．设置简单好记的密码

set password=password("123456");

5．进入msyql库

use mysql

6．查询user表

select user, host from user;

7．修改user表，把Host表内容修改为%

update user set host="%" where user="root";

8．刷新

flush privileges;

10．退出

quit;