python 远程连接mysql

python 远程连接mysql

import pymysql
'''class dealmysql:
    def __init__(self):
        self.content = pymysql.connect(
            host='159.75.127.51',
            user='root',
            passwd='lwx856839',
            db='edison',
            charset='utf8',
        )
        self.curor=self.content.cursor()
    def queryMyql(self):
        sqlyj = "select*from user;"
        self.curor.execute(sqlyj)
        for row in self.curor.fetchall():
            print(row)
    def end(self):
        self.curor.close()
        self.content.close()
if __name__ == '__main__':
    mysql = dealmysql()
    mysql.queryMyql()
    mysql.end()'''

myql = pymysql.connect(
    host='159.75.127.51',#服务器IP
    user='root',    # 用户名
    passwd='lwx856839',# 密码
    db='edison',#数据库名字
    charset='utf8',#字符集
)
cur = myql.cursor()
sqlyj = "select*from userinfo;"
ret = cur.execute(sqlyj)
for row in cur.fetchall():
    print(row)