adding host='localhost' or host='127.0.0.1' to the parameters for the "cnx" object produces the exact same error.
#Python mysql ssh tunnel how to#
This Plone tutorial teaches you how to connect to localhost:3306 with MySQL Query Browser by building SSH. User privileges for the user on the database have been confirmed as GRANT ALL. How to Connect to MySQL via SSH Tunnel in Windows.I tried passing the password string as a raw string, to see if somehow the Python string syntax wasn’t being received by the MySQL db correctly, and still received the same error.I have already confirmed my user and password are valid.erauth_publickey_fromfile(user, r'C:\Users\user\Docs\ssh-key')Ĭnx = (user='username', password='$gHj1aFaVFRfhl*C', database='analyst_db')įile “C:\Users\user\AppData\Local\Programs\Python\Python36-32\lib\site- packages\mysql\connector\connection.py”, line 176, in _auth_switch_request raise errors.get_exception(packet) : 1045 (28000): Access denied for user (using password: YES) The following options are available with this method: ssh: The URI for connection to the SSH server.
Sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM) Here is what I’ve written so far: import socket Example of a port forwarding for the Vagrant MySQL local port: from sshtunnel import opentunnel from time import sleep with. I am trying to write a script that connects to a server, then connects to a MySQL db (which I currently can do via Navicat - so I know my username and password for the MySQL connection are correct).
0 kommentar(er)
