# -*- coding: utf-8 -*-
"""在现有 MySQL 上建一个全新空库，用于验证「一键安装」的首次启动自举"""
import pymysql, sys

DB = 'rmsys_install_test'
c = pymysql.connect(host='192.168.20.66', user='tanghouhu', password='admin123#@!', charset='utf8mb4')
cur = c.cursor()
cur.execute(f"DROP DATABASE IF EXISTS {DB}")
cur.execute(f"CREATE DATABASE {DB} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci")
cur.execute(f"SHOW DATABASES LIKE '{DB}'")
print("已建空库:", cur.fetchone())
c.close()