局域网连mysql数据库

SET GLOBAL wait_timeout = 3600; -- 设置等待超时时间为1小时

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

# 在Linux系统中使用iptables允许3306端口
sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT
sudo iptables -A OUTPUT -p tcp --sport 3306 -j ACCEPT

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="192.168.1.100",  # 数据库服务器的局域网IP地址
        user="your_username",
        password="your_password",
        database="your_database"
    )
    cursor = connection.cursor()
    cursor.execute("SELECT * FROM your_table")
    results = cursor.fetchall()
    for row in results:
        print(row)
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()