# 添加以下参数
net.core.somaxconn = 65535
net.ipv4.tcp_max_syn_backlog = 65535
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_keepalive_time = 300
net.ipv4.tcp_keepalive_probes = 5
net.ipv4.tcp_keepalive_intvl = 15

# 应用内核参数
sysctl -p

# 2. 定期备份计划
# 创建备份脚本
cat > /root/backup_mysql.sh << EOF #!/bin/bash DATE=$(date +%Y%m%d) BACKUP_DIR="/backup/mysql" mkdir -p $BACKUP_DIR mysqldump -u root -p"fgedudb123" --all-databases --single-transaction > $BACKUP_DIR/backup_$DATE.sql

gzip $BACKUP_DIR/backup_$DATE.sql

# 删除7天前的备份
find $BACKUP_DIR -name “backup_*.sql.gz” -mtime +7 -delete
EOF

# 赋予执行权限
chmod +x /root/backup_mysql.sh

# 添加到crontab，每天凌晨2点执行
crontab -e
0 2 * * * /root/backup_mysql.sh

# 2. 创建专用用户并授权
mysql -u root -p
CREATE USER ‘fgedu’@’localhost’ IDENTIFIED BY ‘fgedudb123’;
GRANT ALL PRIVILEGES ON *.* TO ‘fgedu’@’localhost’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

# 3. 限制远程访问
# 在my.cnf中添加
bind-address=127.0.0.1

# 4. 定期更新密码
# 每90天更新一次root密码
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;

# 2. 查看版本
mysql> SELECT VERSION();
+———–+
| VERSION() |
+———–+
| 5.7.36 |
+———–+
1 row in set (0.00 sec)

# 3. 创建测试数据库
mysql> CREATE DATABASE fgedudb;
Query OK, 1 row affected (0.00 sec)

# 4. 创建测试表
mysql> USE fgedudb;
Database changed
mysql> CREATE TABLE fgedu_users (
-> id INT PRIMARY KEY AUTO_INCREMENT,
-> name VARCHAR(50) NOT NULL,
-> age INT,
-> email VARCHAR(100)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.01 sec)

# 5. 插入测试数据
mysql> INSERT INTO fgedu_users (name, age, email) VALUES (‘测试用户’, 25, ‘test@fgedu.net.cn’);
Query OK, 1 row affected (0.00 sec)

# 6. 查询测试数据
mysql> SELECT * FROM fgedu_users;
+—-+———–+—–+———————+
| id | name | age | email |
+—-+———–+—–+———————+
| 1 | 测试用户 | 25 | test@fgedu.net.cn |
+—-+———–+—–+———————+
1 row in set (0.00 sec)

# 7. 退出MySQL
mysql> EXIT