企业官网建设流程全解析

1、安装包下载

地址：https://dev.mysql.com/downloads/mysql/

版本：Linux - Generic (glibc 2.28) (x86, 64-bit), Compressed TAR Archive

2、基础配置

1. 安装依赖
sudo apt install -y libaio1t64 libnuma1 libncurses6
2. 创建 MySQL 用户
sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql
3. 下载并解压（以 8.4.10 为例，去官网查最新小版本）
cd /tmp
tar -xvf mysql-8.4.11-linux-glibc2.28-x86_64.tar.xz
sudo mv mysql-8.4.11-linux-glibc2.28-x86_64 /usr/local/mysql
sudo mkdir -p /data/mysql/{data,tmp} /var/log/mysql/err.log
sudo chown -R mysql:mysql /usr/local/mysql /data/mysql /var/log/mysql/err.log

3、创建配置文件

[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
pid-file=/data/mysql/data/mysqld.pid
port=3306
user=mysql
log-error=/var/log/mysql/error.log
tmpdir=/data/mysql/tmp
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
bind-address=172.19.0.37

[client]
socket=/tmp/mysql.sock
default-character-set=utf8mb4

4、初始化数据库

/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/my.cnf --initialize --user=mysql

cat /data/mysql/error.log | grep 'temporary password' 临时密码

5、添加mysqld.service

cat /etc/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
After=network.target
StartLimitIntervalSec=60
StartLimitBurst=3

[Service]
Type=notify
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
TimeoutStartSec=300
TimeoutStopSec=300
Restart=on-failure
RestartPreventExitStatus=1
RestartSec=5
LimitNOFILE=65535
LimitNPROC=65535

[Install]
WantedBy=multi-user.target

6、启动命令

sudo systemctl daemon-reload

sudo systemctl start mysqld