# 验证安装包完整性
# md5sum mysql84-community-release-el9-1.noarch.rpm

# 安装MySQL服务器
# yum install -y mysql-community-server

# 验证安装
# rpm -qa | grep mysql
mysql-community-server-8.4.0-1.el9.x86_64
mysql-community-client-8.4.0-1.el9.x86_64
mysql-community-common-8.4.0-1.el9.x86_64
mysql-community-libs-8.4.0-1.el9.x86_64

# 设置MySQL服务开机自启
# systemctl enable mysqld

# 查看MySQL服务状态
# systemctl status mysqld
● mysqld.service – MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2026-04-01 10:00:00 CST; 1min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Main PID: 12345 (mysqld)
Status: “Server is operational”
Tasks: 38 (limit: 32768)
Memory: 450.0M
CPU: 1.2s
CGroup: /system.slice/mysqld.service
└─12345 /usr/sbin/mysqld

# 获取初始密码
# grep ‘temporary password’ /var/log/mysqld.log
2026-04-01T02:00:00.000000Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Xxxxxxxx

# 修改root密码
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Fgedu123!’;
Query OK, 0 rows affected (0.01 sec)

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

# 退出MySQL
mysql> exit
Bye

# 重新登录验证
# mysql -u root -p
Enter password: Fgedu123!
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.0 MySQL Community Server – GPL

Copyright (c) 2000, 2026, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

# 创建配置文件
# vi /etc/my2.cnf
[mysqld]
port=3307
basedir=/usr
datadir=/mysql/data2
socket=/var/lib/mysql/mysql2.sock
pid-file=/var/run/mysqld/mysql2.pid
server-id=2

# 初始化实例
# mysqld –defaults-file=/etc/my2.cnf –initialize-insecure –user=mysql

# 创建服务文件
# vi /usr/lib/systemd/system/mysqld2.service
[Unit]
Description=MySQL Server 2
After=network.target

[Service]
Type=forking
User=mysql
Group=mysql
ExecStart=/usr/sbin/mysqld –defaults-file=/etc/my2.cnf
ExecStop=/usr/bin/mysqladmin –defaults-file=/etc/my2.cnf shutdown
Restart=on-failure

[Install]
WantedBy=multi-user.target

# 重载系统服务
# systemctl daemon-reload

# 启动服务
# systemctl start mysqld2
# systemctl enable mysqld2

# 连接实例
# mysql -u root -P 3307 -S /var/lib/mysql/mysql2.sock -p

# 创建远程用户
mysql> CREATE USER ‘fgedu’@’%’ IDENTIFIED BY ‘Fgedu123!’;
Query OK, 0 rows affected (0.01 sec)

# 授予权限
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘fgedu’@’%’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

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

# 配置防火墙
# firewall-cmd –permanent –add-port=3306/tcp
success
# firewall-cmd –reload
success