内网ip连不上mysql数据库

# 在Linux系统上，使用iptables允许特定IP访问MySQL端口
sudo iptables -A INPUT -p tcp -s 内网IP --dport 3306 -j ACCEPT

[mysqld]
bind-address = 0.0.0.0  # 允许所有IP连接

sudo systemctl restart mysqld

GRANT ALL PRIVILEGES ON *.* TO 'username'@'内网IP' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

ping MySQL服务器IP
telnet MySQL服务器IP 3306

import pymysql

try:
    connection = pymysql.connect(
        host='内网IP',
        user='username',
        password='password',
        db='database_name',
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
    print("成功连接到数据库")
except pymysql.MySQLError as e:
    print(f"连接失败: {e}")
finally:
    if connection:
        connection.close()