Look_for_keys=has_key, allow_agent=has_key)įile “C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/python/site-packages\paramiko\client.py”, line 301, in connectįile “C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/python/site-packages\paramiko\transport.py”, line 461, in start_client This looked promising to me, but i’m unable to connect using this method.Īuthentication error, unhandled exception caught in tunnel manager, please refer to logs in detailsġ7:37:43 : TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for detailsġ7:37:43 : Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for detailsġ7:38:49 : Existing SSH tunnel not found, opening new oneġ7:38:49 : Opening SSH tunnel to :22ġ7:38:49 : IOError, probably caused by file C:\Users\cutups\AppData\Roaming\MySQL\Workbench\ssh\known_hosts not found, the message was: No such file or directory: u’C:\Users\cutups\AppData\Roaming\MySQL\Workbench\ssh\known_hosts’ġ7:38:49 : Traceback (most recent call last):įile “C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\sshtunnel.py”, line 298, in _connect_ssh You can change it back to auth_socket later when you are done if you are concerned about security. To fix it, follow the instructions at Configuring Password Access for the MySQL Root Account here: -adjusting-user-authentication-and-privileges to change from auth-socket to caching_sha2_password or the older mysql_native_password and you should be able to connect. If you are getting an error from mysql workbench when trying to connect of: Access denied for user this is likely the cause. ![]() This allows you to connect using the mysql prompt when connected to the droplet via ssh, but not from outside (even though the ssh tunnel connection part of your workbench connection profile is working). ![]() ![]() I had done all of the above and still was not able to connect workbench to the mysql db in my lemp droplet.įor the default lemp droplet on the marketplace, the root mysql user is configured to authenticate via auth_socket instead of password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |