python连接远程mysql程序demo

先上demo：

#!/usr/bin/env python 
# -*- coding:utf-8 -*-
# author: Frank  time:2020/8/21


import pymysql


class Mysql:
    def __init__(self):
        self.content = pymysql.Connect(
            host='X.X.X.X',  # mysql的主机ip
            port=3306,  # 端口
            user='root',  # 用户名
            passwd='XXXXXX',  # 数据库密码
            db='XXXX',  # 数据库名
            charset='utf8',  # 字符集
        )
        self.cursor = self.content.cursor()

    def query(self):
        sql = "select * from XXX;"
        self.cursor.execute(sql)
        for row in self.cursor.fetchall():
            print('Api_name = %s'%row[0])
            print("Api_pwd = %s" %row[1])
            #print("name:%s\t url:%s" %row)

        print(f"一共查找到：{self.cursor.rowcount}")


    def end(self):
        self.cursor.close()
        self.content.close()


if __name__ == '__main__':
    mysql = Mysql()
    mysql.query()
    mysql.end()