SSH TUNNEL MYSQL GENERATOR

You can safely connect to the distant MySQL server from your local client by creating an SSH tunnel. You will see a screen similar to this appear: For Connection Method, select Standard TCP/IP over SSH Set the name to whatever you want, preferably an easily recognizable label. MySQL, the most widely used open-source database server, only accepts connections from localhost. First, open MySQL Workbench and click the + icon next to MySQL Connections.

If this does not work with a simple example then you definitely have an ssh tunnel connection issue and it is not some basic anvil server module behavior that behaves differently from your local machine. Once we have your SSH key on our server, configure MySQL Workbench to connect. #proceed with rest of your code/test as normal #turn the generator-like MySQL cursor object iterator into a list comprehension Sql_query = 'FROM `your_table` SELECT * LIMIT 5 ' MySQL by default listens on port 3306 and were connecting locally to the server itself. This means, from the server, forward the connection to IP 127.0.0.1 port 3306. So what I would try first: mysqlcursor = connection.cursor() This is the port PuTTY will listen on on your local machine.

SSH TUNNEL MYSQL GENERATOR

postgresql ), so pymysql will create a pythonic SQL standardized ‘cursor-like’ object for it that sometimes can act more like a generator object attached to a stream. MySQL does not actually have a cursor like other SQL dbs do (ex. This may or may not be the answer, but the first thing I would do is attempt to convert the pymysql cursor object to a normalized python type in memory to make sure it does not require any lingering connection just to return the results you are asking for after you have already closed the connection.

Ssh tunnel mysql