如何在pycharm社区版中连接mysql？

bashpip install mysql-connector-python

bashpip install pymysql

pythonimport mysql.connector

# 设置数据库连接参数
config = {
    'user': '<username>',
    'password': '<password>',
    'host': '<host>',
    'database': '<database>',
    'raise_on_warnings': True
}

try:
    # 建立连接
    cnx = mysql.connector.connect(**config)

    # 创建游标
    cursor = cnx.cursor()

    # 执行查询
    query = "SELECT * FROM your_table_name"
    cursor.execute(query)

    # 打印查询结果
    for row in cursor:
        print(row)

except mysql.connector.Error as err:
    print(f"Error: {err}")

finally:
    # 关闭游标和连接
    if 'cursor' in locals() or 'cursor' in globals():
        cursor.close()
    if 'cnx' in locals() or 'cnx' in globals():
        cnx.close()

pythonimport pymysql

try:
    # 建立连接
    cnx = pymysql.connect(
        host='<host>',
        user='<username>',
        password='<password>',
        database='<database>'
    )

    # 创建游标
    cursor = cnx.cursor()

    # 执行查询
    query = "SELECT * FROM your_table_name"
    cursor.execute(query)

    # 打印查询结果
    for row in cursor:
        print(row)

except pymysql.Error as err:
    print(f"Error: {err}")

finally:
    # 关闭游标和连接
    if 'cursor' in locals() or 'cursor' in globals():
        cursor.close()
    if 'cnx' in locals() or 'cnx' in globals():
        cnx.close()