3. Connect to Remote Database(Mysql) Through SSH connection using Python

How can we connect to Remote Database(Mysql) Through SSH connection using Python

[@pythoncodingwithnihal-pyth1979]

why it is getting considerable time to transfer data....

[@100pakkavalidcode2]

Sorry i didn't get your question.?

[@pythoncodingwithnihal-pyth1979]

@@100pakkavalidcode2 I mean it is very slow. But working

[@100pakkavalidcode2]

Oh. Ok Thank you❤

Thanks for sharing! I used the pymysql module to perform the db connection. Regards from Colombia!

[@100pakkavalidcode2]

Very cool!

[@gulshankumar-lj7el]

Hi, when i tried to connect to remote database through this code , it is helping me to connect to the server but i am not able to connect to database and program goes on running, not even showing any error. Do you have any solution for that

[@100pakkavalidcode2]

In the remote side. Is database installed? Which database you are using?

[@matinxrc]

I have same issue!...

[@matinxrc]

do you find any solution? Its so serious! 😥

[@Saatwiksaahithi]

Super

[@yasarasamarathunga7532]

how to find the remote bind address

[@100pakkavalidcode2]

Please search in google

[@bee_dmytro]

What python code should be if my sql connection needs ssh key - id_rsa.pub?

[@michaelwang9171]

give you some hints: 1) paramiko library 2)SSHTunnelForwarder(ssh_pkey=pkey)

[@100pakkavalidcode2]

Use as same code