Ubuntu下如何配置Python數據庫連接

在Ubuntu下配置Python數據庫連接，首先需要確保已經安裝了相應的數據庫和Python數據庫驅動。以下是一些常見數據庫的配置方法：

1. MySQL

步驟1：安裝MySQL服務器

sudo apt-get update
sudo apt-get install mysql-server

步驟2：安裝Python MySQL驅動

pip install mysql-connector-python

步驟3：編寫Python代碼連接MySQL數據庫

import mysql.connector

cnx = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = cnx.cursor()

query = "SELECT * FROM your_table"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
cnx.close()

2. PostgreSQL

步驟1：安裝PostgreSQL服務器

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib

步驟2：安裝Python PostgreSQL驅動

pip install psycopg2

步驟3：編寫Python代碼連接PostgreSQL數據庫

import psycopg2

conn = psycopg2.connect(
    dbname="your_database",
    user="your_username",
    password="your_password",
    host="localhost"
)

cursor = conn.cursor()

query = "SELECT * FROM your_table"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
conn.close()

3. SQLite

步驟1：安裝SQLite3

sudo apt-get update
sudo apt-get install sqlite3 libsqlite3-dev

步驟2：編寫Python代碼連接SQLite數據庫

import sqlite3

conn = sqlite3.connect("your_database.db")

cursor = conn.cursor()

query = "SELECT * FROM your_table"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
conn.close()

根據需要選擇合適的數據庫，并按照上述步驟進行配置。如果需要連接其他類型的數據庫，請查閱相應的Python驅動文檔。