mysql服务中出现错误

# 检查MySQL服务器是否启动
sudo systemctl status mysql

# 启动MySQL服务器
sudo systemctl start mysql

# 检查配置文件
cat /etc/mysql/my.cnf | grep port
cat /etc/mysql/my.cnf | grep user

# 授予用户权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

# 检查表是否损坏
CHECK TABLE your_table_name;

# 修复表
REPAIR TABLE your_table_name;

# 增加系统内存（示例）
sudo apt-get install -y more_memory

# 优化MySQL配置
sudo nano /etc/mysql/my.cnf
# 修改以下配置项
[mysqld]
innodb_buffer_pool_size = 1G
max_connections = 500

# 开启慢查询日志
SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 2;

# 分析慢查询日志
sudo tail -f /var/log/mysql/slow-query.log