命令操作mysql数据库

# 检查MySQL服务状态
sudo systemctl status mysql

# 启动MySQL服务
sudo systemctl start mysql

# 检查防火墙设置
sudo ufw allow mysql

-- 查看错误信息
SHOW ERRORS;

-- 授予相应权限
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

-- 检查并修复数据表
CHECK TABLE table_name;
REPAIR TABLE table_name;

-- 分析慢查询日志
ANALYZE TABLE table_name;

-- 创建索引
CREATE INDEX idx_column_name ON table_name(column_name);

-- 优化硬件配置

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
mycursor = mydb.cursor()

# 执行SQL查询
mycursor.execute("SELECT * FROM customers")

# 获取查询结果
myresult = mycursor.fetchall()

for x in myresult:
  print(x)