Python连接redis和mysql

# 连接mysql
import pymysql


def conn_mysql():
    host = "mysql的IP"
    port = 3306
    user = "账号"
    password = "密码"
    database = "数据库"
    charset = "utf8"
    conn = pymysql.connect(host=host, port=port, user=user, password=password, database=database, charset=charset)

    # 创建游标
    yb = conn.cursor()

    sql = "sql语句"

    yb.execute(sql)

    ret = yb.fetchall()

    yb.close()
    conn.close()

    print(ret)


if __name__ == '__main__':
    conn_mysql()

# 连接redis
import redis

redis_conn = redis.Redis(host="ip", port=6379, db=2, password="密码")
ret = redis_conn.get("1163")
print(ret)