pymysql接数据库

最新推荐文章于 2022-05-11 18:57:33 发布

写if不写else

最新推荐文章于 2022-05-11 18:57:33 发布

阅读量115

点赞数

分类专栏： vender redis 文章标签： python 数据库 sql

本文链接：https://blog.csdn.net/weixin_41429587/article/details/119328231

版权

redis 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

vender

2 篇文章 0 订阅

订阅专栏

基本的链接查询

import pymysql
from sshtunnel import SSHTunnelForwarder
import time
import openpyxl
if __name__=='__main__':
    with SSHTunnelForwarder(
        ('192.168.110.218',22),
        ssh_password="dimarts218",
        ssh_username="root",
        remote_bind_address=('192.168.110.218',3306) 
        ) as server:
        db = pymysql.connect(host='127.0.0.1',port=server.local_bind_port,user='root',
                             password='dimarts@mysql',database='s999_tcr')
        sql = 'select * from user;'
        cursor = db.cursor()
        cursor.execute(sql)
        data = cursor.fetchall()
        for x in range(len(data)):
            print(data[x])
            print('*****************'+'\n')
       
    
    db.close()