CentOS 7.9 安装 MySQL 8.0 并设置密码
操作环境为 腾讯云 CentOS 7.9
安装 mysql repo
yum install epel-release -y
yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
// 查看启用的 mysql 版本
yum repolist enabled | grep mysql
更改 mysql 8.0 源加速
备份源文件
cp /etc/yum.repos.d/mysql-community.repo /etc/yum.repos.d/mysql-community.repo.bak
设置 [mysql80-community] 的 baseurl 为 https://mirrors.cloud.tencent.com/mysql/yum/mysql-8.0-community-el7-x86_64/
, 更改后如下:
...省略前面
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=https://mirrors.cloud.tencent.com/mysql/yum/mysql-8.0-community-el7-x86_64/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
...省略后面
安装 mysql 8
yum update -y
yum install -y mysql-community-server
# 启动 mysql
systemctl start mysqld.service
# 设置为开机启动 mysql
systemctl enable mysqld.service
查找 mysql root 密码
grep 'temporary password' /var/log/mysqld.log
更改 root 密码、删除匿名账号、test 数据库等
mysql_secure_installation
添加新的 mysql 账号 wwwdb
create user 'wwwdb'@'%' identified by '密码';
grant all privileges on *.* to 'wwwdb'@'%';
flush privileges;
注意新版本需要先创建账号再进行授权