docker centos7在线安装mysql8.x

1. 安装mysql8.x

# 安装MySQL
cd /usr/local/mysql
# 下载rpm安装包
wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
yum -y localinstall mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
yum install mysql-server
yum install mysql-community-server --nogpgcheck

2.配置开机启动

# 启动
systemctl start mysqld
# 开机自启
systemctl enable mysqld
# 重载启动项
systemctl daemon-reload

3.修改root密码和配置远程访问

# 查看临时密码
grep 'temporary password' /var/log/mysqld.log

使用临时密码登录mysql：

mysql -u root -p

修改root密码：

ALTER USER 'root'@'%' IDENTIFIED BY '你的新密码';
use mysql;
update user set Host='%' where User='root';
flush privileges;