代码:
import subprocess
import os
from dotenv import load_dotenv
import pymysql
from sqlalchemy import create_engine
def check_mysql_service():
"""检查 MySQL 服务是否运行"""
try:
result = subprocess.run(
["systemctl", "is-active", "mysql"],
capture_output=True,
text=True
)
if "active" in result.stdout:
print("✅ MySQL 服务正在运行")
return True
else:
print(f"❌ MySQL 服务未运行: {result.stdout}")
return False
except Exception as e:
print(f"⚠️ 无法检查服务状态: {str(e)}")
return False
def test_mysql_login(user, password):
"""测试命令行登录"""
try:
cmd = f"mysql -u {user} -p{password} -e 'SELECT 1;'"
result = subprocess