本篇文章还是失败了,因为CentOS8停更了,有些组件装不上去。
上一文章:
【入门】【失败】Linux下
mysql-8.0.22-linux-x64.tar.gz 安装
看到攻略建议我安装
mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz,学习的态度
我这里笔记一下安装
首先创建用户组和用户
解压并移动到指定目录
# 解压文件
tar -xvf mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz
# 移动到 /usr/local/mysql
sudo mv mysql-8.0.33-linux-glibc2.17-x86_64-minimal /usr/local/mysql
# 设置权限
sudo chown -R mysql:mysql /usr/local/mysql
创建必要目录与配置文件
# 创建数据目录
sudo mkdir -p /var/lib/mysql
sudo chown mysql:mysql /var/lib/mysql
# 创建配置文件
sudo vi /etc/my.cnf
配置文件内容建议如下:
[mysqld]
basedir = /usr/local/mysql
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
port = 3306
character-set-server = utf8mb4
default-authentication-plugin = mysql_native_password
[client]
socket = /var/lib/mysql/mysql.sock
初始化 MySQL
# 初始化数据目录
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql
# 记录临时密码(初始化输出中 'temporary password' 后面的字符串)
发现我mv的时候,文件目录错了,重新mv一次
[root@localhost mysql]# sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql
2025-06-22T08:56:53.198422Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-06-22T08:56:53.198437Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.33) initializing of server in progress as process 3479
2025-06-22T08:56:53.219141Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-06-22T08:56:55.968263Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-06-22T08:57:01.036157Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: VoDQg.FsU86D
临时密码:VoDQg.FsU86D
配置系统服务
# 复制服务脚本
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
# 设置开机启动
sudo systemctl enable mysqld
# 启动 MySQL 服务
sudo systemctl start mysqld
# 检查服务状态
sudo systemctl status mysqld
安全设置
# 使用临时密码登录
sudo /usr/local/mysql/bin/mysql -u root -p
# 修改 root 密码(需符合密码策略)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourNewPassword123!';
# 运行安全脚本
sudo /usr/local/mysql/bin/mysql_secure_installation