1. 準備工作
sudo yum update -y
sudo yum install -y wget libaio numactl
2. 下載 MySQL 5.7 二進制包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz
3. 創建 MySQL 用戶和組
sudo groupadd mysql
sudo useradd -r -g mysql -s /bin/false mysql
4. 解壓并安裝 MySQL
sudo tar -zxvf mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
sudo ln -s /usr/local/mysql-5.7.44-linux-glibc2.12-x86_64 /usr/local/mysql
5. 創建數據目錄并設置權限
sudo mkdir -p /var/lib/mysql
sudo chown -R mysql:mysql /var/lib/mysql
sudo chown -R mysql:mysql /usr/local/mysql
6. 初始化 MySQL
cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqld
?
2025-05-28T02:52:48.238588Z 1 [Note] A temporary password is generated for root@localhost: (lqoeIokr3y=
7. 配置 MySQL 服務
vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/data/mysql/data/mysql.sock
user=mysql
symbolic-links=0
[mysqld_safe]
log-error=/data/mysql/log/mysqld.log
pid-file=/data/mysql/run/mysqld.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
8. 創建 systemd 服務文件
sudo cp support-files/mysql.server /etc/init.d/mysqld
sudo chmod +x /etc/init.d/mysqld
創建 systemd 服務文件 /usr/lib/systemd/system/mysqld.service：
[Unit]
Description=MySQL Server
After=network.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
ExecStop=/usr/local/mysql/bin/mysqladmin shutdown
Restart=on-failure
RestartSec=5
[Install]
WantedBy=multi-user.target
9. 啟動 MySQL 服務
sudo systemctl daemon-reload
sudo systemctl start mysqld
sudo systemctl enable mysqld
10. 設置環境變量
echo 'export PATH=$PATH:/usr/local/mysql/bin' >> ~/.bashrc
source ~/.bashrc
導入數據
方法1、mysql -u root ?-p < /data/bak/eblp.sql
方法2、進入使命行后
use db;
SOURCE /home/qitan/soft/mysql/dna.sql;
11. 安全設置和修改 root 密碼
mysql -u root -p
然后修改 root 密碼：
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的新密碼';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'dna@2025';
FLUSH PRIVILEGES;
12. 可選配置
如果需要遠程訪問：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密碼' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'dna@2025' WITH GRANT OPTION;
FLUSH PRIVILEGES;
驗證安裝
mysql --version
systemctl status mysqld
創建用戶
CREATE USER 'user_eblp'@'%' IDENTIFIED BY '你的密碼';
GRANT ALL PRIVILEGES ON eblp.* TO 'user_eblp'@'%';
FLUSH PRIVILEGES;
驗證權限wh
sql
SHOW GRANTS FOR 'user_eblp'@'%';
