无法连接云服务器mysql数据库

# 示例：在腾讯云控制台的安全组设置中添加入站规则
# 允许TCP 3306端口，来源IP填写你的IP地址或0.0.0.0/0（不推荐用于生产环境）

# 注释掉或修改为
# bind-address = 127.0.0.1
bind-address = 0.0.0.0

sudo systemctl restart mysqld

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

# 在Linux服务器上使用iptables允许3306端口
sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

sudo systemctl status mysqld
sudo systemctl start mysqld

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="your_server_ip",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    print("Connected to MySQL database!")
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if connection.is_connected():
        connection.close()