远程调用centos中的mysql数据库

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

sudo systemctl restart mysqld

mysql -u root -p

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

sudo firewall-cmd --permanent --add-port=3306/tcp
sudo firewall-cmd --reload

import pymysql

# 连接数据库
conn = pymysql.connect(
    host='your_server_ip',
    user='username',
    password='password',
    db='database_name',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

try:
    with conn.cursor() as cursor:
        # 创建表
        sql = "CREATE TABLE IF NOT EXISTS `users` (`id` INT AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(255) NOT NULL)"
        cursor.execute(sql)
        conn.commit()

        # 插入数据
        sql = "INSERT INTO `users` (`name`) VALUES (%s)"
        cursor.execute(sql, ('Alice',))
        conn.commit()

        # 查询数据
        sql = "SELECT * FROM `users`"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    conn.close()