10.2 MySQL 8 安装

# 安装 MySQL 8 官方 YUM 源
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
# 安装 MySQL 8
sudo yum install -y mysql-community-server
# 启动并设置开机自启
sudo systemctl start mysqld
sudo systemctl enable mysqld
# 查看初始密码
sudo grep 'temporary password' /var/log/mysqld.log
# 运行安全配置向导
sudo mysql_secure_installation

# 更新包索引
sudo apt update
# 安装 MySQL 8
sudo apt install -y mysql-server-8.0
# 启动并设置开机自启
sudo systemctl start mysql
sudo systemctl enable mysql
# 查看初始密码
sudo grep 'temporary password' /var/log/mysql/error.log
# 运行安全配置向导
sudo mysql_secure_installation

# 登录 MySQL（使用初始密码）
mysql -u root -p
# 修改 root 密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NewPassword123!';
# 创建新用户并授权远程访问
CREATE USER 'myuser'@'%' IDENTIFIED BY 'MyPassword123!';
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
# 配置远程访问（编辑 /etc/my.cnf 或 /etc/mysql/mysql.conf.d/mysqld.cnf）
bind-address = 0.0.0.0