远程连接linux数据库服务器配置

sudo systemctl enable ssh
sudo systemctl start ssh

# bind-address = 127.0.0.1
bind-address = 0.0.0.0

sudo systemctl restart mysql

mysql -u root -p

CREATE USER 'remote_user'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'remote_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

sudo iptables -A INPUT -p tcp --dport 22 -j ACCEPT
sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT
sudo service iptables save

ssh -L 3307:localhost:3306 remote_username@remote_server_ip

import pymysql
from sshtunnel import SSHTunnelForwarder

with SSHTunnelForwarder(
    ('remote_server_ip', 22),
    ssh_username='remote_username',
    ssh_password='remote_password',
    remote_bind_address=('localhost', 3306)
) as tunnel:
    conn = pymysql.connect(
        host='127.0.0.1',
        port=tunnel.local_bind_port,
        user='remote_user',
        password='your_password',
        db='your_database'
    )
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM your_table")
    results = cursor.fetchall()
    for row in results:
        print(row)
    conn.close()