虚拟机MySQL安装

安装步骤

# MySQL安装
# 1.查看yum源列表
yum list 

# 2.解决linux安全密钥过期问题
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

# 3.通过wget下载mysql的rpm包
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

# 4.下载rpm对应的依赖包
yum -y install mysql57-community-release-el7-10.noarch.rpm 

# 5.下载mysql的服务
yum -y install mysql-community-server

# 6.启动mysql服务
systemctl start mysqld

# 7.设置服务自启动
systemctl enable mysqld

# 8.监听服务是否已经开启
netstat -nltp | grep  3306

# 9.修改密码
grep "password" /var/log/mysqld.log    # 查看原始密码
2020-06-24T07:21:25.731630Z 1 [Note] A temporary password is generated for root@localhost: Apd>;WYEc2Ir
2020-06-24T07:21:48.097350Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

# 10.登录，然后再去粘贴密码
mysql -uroot -p

# 11.修改密码
set global validate_password_policy=0;
set global validate_password_length=1;  # 这个两个设置以后，密码很简单不会报错

# 12.执行
set password = password('密码');

# 13.开启远程连接，可以执行以下命令
grant all privileges on *.* to root@"%" identified by "密码";
# 然后直接连接