vps数据库地址

mysql -h 192.168.1.100 -P 3306 -u your_username -p

import mysql.connector

config = {
    'host': '192.168.1.100',
    'port': 3306,
    'user': 'your_username',
    'password': 'your_password',
    'database': 'your_database'
}

try:
    connection = mysql.connector.connect(**config)
    print("Connected to MySQL database")
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if connection.is_connected():
        connection.close()

psql -h 192.168.1.100 -p 5432 -U your_username -d your_database

import psycopg2

config = {
    'host': '192.168.1.100',
    'port': 5432,
    'user': 'your_username',
    'password': 'your_password',
    'database': 'your_database'
}

try:
    connection = psycopg2.connect(**config)
    print("Connected to PostgreSQL database")
except psycopg2.Error as err:
    print(f"Error: {err}")
finally:
    if connection:
        connection.close()