代碼:
import subprocess
import os
from dotenv import load_dotenv
import pymysql
from sqlalchemy import create_enginedef 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 Trueelse:print(f"? MySQL 服務未運行: {result.stdout}")return Falseexcept Exception as e:print(f"?? 無法檢查服務狀態: {str(e)}")return Falsedef test_mysql_login(user, password):"""測試命令行登錄"""try:cmd = f"mysql -u {user} -p{password} -e 'SELECT 1;'"result = subprocess