linux系统数据库服务器配置

# 检查日志文件
tail -f /var/log/mysql/error.log

# 确保依赖服务（如网络）正常运行
systemctl status network

# 检查文件权限
chown -R mysql:mysql /var/lib/mysql

# 使用EXPLAIN分析查询语句
EXPLAIN SELECT * FROM users WHERE id = 1;

# 添加索引
CREATE INDEX idx_user_id ON users(id);

# 监控系统资源使用情况
top

# 设置强密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'StrongPassword123!';

# 启用SSL
mysql_ssl_rsa_setup --datadir=/var/lib/mysql

# 限制远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

# 安装MySQL
sudo apt update
sudo apt install mysql-server

# 启动MySQL服务
sudo systemctl start mysql

# 运行安全脚本
sudo mysql_secure_installation

# 配置MySQL
sudo nano /etc/mysql/my.cnf
# 添加或修改以下配置
[mysqld]
bind-address = 127.0.0.1
max_connections = 500
innodb_buffer_pool_size = 1G

# 重启MySQL服务
sudo systemctl restart mysql