mysql数据库配置连接字符串

jdbc:mysql://hostname:port/database?user=username&password=password

import mysql.connector

config = {
    'user': 'username',
    'password': 'password',
    'host': 'hostname',
    'database': 'database',
    'raise_on_warnings': True
}

cnx = mysql.connector.connect(**config)

const mysql = require('mysql');

const connection = mysql.createConnection({
  host     : 'hostname',
  user     : 'username',
  password : 'password',
  database : 'database'
});

import mysql.connector

try:
    # 配置连接参数
    config = {
        'user': 'your_username',
        'password': 'your_password',
        'host': 'your_hostname',
        'database': 'your_database',
        'raise_on_warnings': True
    }

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

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

    # 处理结果
    for row in cursor:
        print(row)

except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    # 关闭连接
    if cnx.is_connected():
        cursor.close()
        cnx.close()