Forums

from flask import Flask
import MySQLdb
import sshtunnel

app = Flask(__name__)

sshtunnel.SSH_TIMEOUT = 10.0
sshtunnel.TUNNEL_TIMEOUT = 10.0

with sshtunnel.SSHTunnelForwarder(
    ('ssh.pythonanywhere.com'),
    ssh_username='itookurjob', ssh_password='****',
    remote_bind_address=('itookurjob.mysql.pythonanywhere-services.com', 3306)
) as tunnel:
    connection = MySQLdb.connect(
        user='itookurjob',
        passwd='Pointer12#',
        host='127.0.0.1', port=tunnel.local_bind_port,
        db='itookurjob$mera_ghar',
    )
    # Do stuff
    @app.route('/')
    def index():
        cur = connection.cursor()
        cur.execute('''SELECT * FROM mera_ghar''')
        results = cur.fetchall()
        return str(results)

    if __name__ == '__main__':
        app.run()
    connection. Close()

Exception has occurred: OperationalError
(2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0")
  File "/home/abdul/Documents/flask_pythonanywhere/web_app.py", line 15, in <module>
    connection = MySQLdb.connect(
                 ^^^^^^^^^^^^^^^^
MySQLdb.OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 0")