mysql连接数据库的步骤

import mysql.connector

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

try:
    # 连接到MySQL数据库
    cnx = mysql.connector.connect(**config)
    print("连接成功！")
    cnx.close()
except mysql.connector.Error as err:
    print(f"连接失败: {err}")

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MySQLConnectionExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://your_host:3306/your_database";
        String user = "your_username";
        String password = "your_password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            System.out.println("连接成功！");
        } catch (SQLException e) {
            System.out.println("连接失败: " + e.getMessage());
        }
    }
}