mysql8.0.34在centos7.0上的安装

1.安装

1.在finalshell中配置yum仓库 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

2.执行rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm

rpm -Uvh https://dev.mysql.com/get/mysql80-community-release​​​​​​​-el7-2.noarch.rpm

 

3.执行 yum -y install mysql-community-server

 yum -y install mysql-community-server

4.启动mysql

 systemctl start mysqld

5.执行开机自启

systemctl enable mysqld

6.检查MySQL状态，绿色的active证明已开启。

systemctl status mysqld

7.复制初始密码

grep 'temporary password' /var/log/mysqld.log

8.启动mysql，输入密码进入

mysql -uroot -p

9.修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';

10.验证密码ctrl+d退出mysql

输入mysql -uroot -p输入修改的密码。

11.配置简单的密码

set global validate_password.policy=0;
set global validate_password.length=4;

12.重新执行修改密码的语句

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

13.重新用新密码123456登录

14.设置远程密码

create user 'root'@'%' identified by '123456';

15.检查3306端口，3306被MySQL占用证明运行成功。

 netstat -anp | grep 3306