判断mysql数据库是否存在

SHOW DATABASES LIKE 'database_name';

mysql -u username -p -e "SHOW DATABASES LIKE 'database_name';"

import mysql.connector

def check_database_exists(host, user, password, database_name):
    try:
        conn = mysql.connector.connect(host=host, user=user, password=password)
        cursor = conn.cursor()
        cursor.execute(f"SHOW DATABASES LIKE '{database_name}'")
        result = cursor.fetchone()
        return result is not None
    except mysql.connector.Error as err:
        print(f"Error: {err}")
        return False
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 示例调用
host = 'localhost'
user = 'your_username'
password = 'your_password'
database_name = 'your_database_name'

if check_database_exists(host, user, password, database_name):
    print(f"Database '{database_name}' exists.")
else:
    print(f"Database '{database_name}' does not exist.")

GRANT SELECT ON *.* TO 'username'@'localhost';