import os
import gzip
import io
import pymysql

# Connect to MySQL server
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='Remember#0503'
)

# Get a cursor object
cursor = conn.cursor()

# Loop through files in directory
for filename in os.listdir('/var/www/html/kuma_test'):
    if filename.startswith('databases-') and filename.endswith('.gz'):
        # Create new database
        db_name = filename[10:-3]
        cursor.execute(f"CREATE DATABASE IF NOT EXISTS {db_name}")

        # Create new user
        user_password = 'Remember#'
        cursor.execute(f"CREATE USER '{db_name}'@'localhost' IDENTIFIED BY '{user_password}'")

        # Grant privileges to user on database
        cursor.execute(f"GRANT ALL PRIVILEGES ON {db_name}.* TO '{db_name}'@'localhost'")

# Commit changes and close connection
conn.commit()
conn.close()