mysql从脚本里连接数据库

import MySQLdb

# 连接到MySQL数据库
conn = MySQLdb.connect(
    host="localhost",
    user="username",
    passwd="password",
    db="database_name"
)

# 创建游标对象
cursor = conn.cursor()

# 执行SQL查询
cursor.execute("SELECT * FROM table_name")

# 获取查询结果
result = cursor.fetchall()

# 关闭游标和数据库连接
cursor.close()
conn.close()

import java.sql.*;

// 连接到MySQL数据库
String url = "jdbc:mysql://localhost:3306/database_name";
String username = "username";
String password = "password";
Connection conn = DriverManager.getConnection(url, username, password);

// 创建Statement对象
Statement stmt = conn.createStatement();

// 执行SQL查询
String sql = "SELECT * FROM table_name";
ResultSet rs = stmt.executeQuery(sql);

// 获取查询结果
while (rs.next()) {
    // 处理每一行数据
}

// 关闭结果集、Statement和数据库连接
rs.close();
stmt.close();
conn.close();

// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 执行SQL查询
$sql = "SELECT * FROM table_name";
$result = $conn->query($sql);

// 获取查询结果
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // 处理每一行数据
    }
} else {
    echo "0 结果";
}

// 关闭结果集和数据库连接
$result->close();
$conn->close();