centos 7.x 安装 mysql 8.x

1. 安装

wget https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
yum -y localinstall mysql80-community-release-el7-11.noarch.rpm 
yum -y install mysql-community-server

2. 启动并设置开机启动

systemctl start mysqld
systemctl enable mysqld
systemctl daemon-reload

3. 修改密码并修改远程访问

#查看原始密码
[root@localhost nginx]# grep "password" /var/log/mysqld.log
2021-10-12T06:55:35.786391Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: X2i<p=nwpQvh

#登录
[root@localhost nginx]# mysql -u root -p

#修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Ui892#2dla33';
Query OK, 0 rows affected (0.01 sec)

#切换数据库
mysql> use mysql
Database changed

#容许任意IP访问
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

#刷新权限
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

4. 访问mysql

ip : 10.10.10.131

port:3306

user：root

password: Ui892#2dla33

5. 移除镜像

yum -y remove mysql80-community-release-el7-11.noarch.rpm 

一切OK