Mysql安装

mysql

链接：https://pan.baidu.com/s/1-PAtXYtiqIkQo6ZLFiF6iA?pwd=k7xn 
提取码：k7xn

一、Mysql安装配置

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

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

2.将安装包和JDBC驱动上传到/opt/software

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

ls *.rpm | xargs -n1 sudo rpm -ivh

1）安装mysql依赖

 sudo rpm -ivh 01_mysql-community-common-5.7.29-1.el7.x86_64.rpm

 sudo rpm -ivh 02_mysql-community-libs-5.7.29-1.el7.x86_64.rpm

 sudo rpm -ivh 03_mysql-community-libs-compat-5.7.29-1.el7.x86_64.rpm

2）安装mysql-client

sudo rpm -ivh 04_mysql-community-client-5.7.29-1.el7.x86_64.rpm

3）安装mysql-server

sudo rpm -ivh 05_mysql-community-server-5.7.29-1.el7.x86_64.rpm

4）启动mysql

sudo systemctl start mysqld

5）查看mysql密码

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

配置MySql

1.用刚刚查到的密码进入mysql

mysql -uroot -p 回车

在第二行输入密码

mysql -uroot -p
Enter password: 

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

mysql> set password=password("Qz24%zfd32");

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;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+

7.修改user表，把Host表内容修改为%,把root的本机登录改为谁都可以登录

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

mysql> select user, host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+

8.刷新

mysql> flush privileges;

9.退出

mysql> quit;