Unable to connect to MySQL Workbench
I’ve been trying to connect my mysql db through workbench over SSH, but I can’t seem to get it to work.
I keep getting the error “Could not connect the SSH Tunnel, please check username and password.” and right after that error “Failed to connect to MySQL at 127.0.0.1:3306 through SSH tunnel at [my droplet ip] with user root”
What I have at the moment:
SSH Hostname: [droplet ip]
SSH username: root
SSH password is blank
SSH key file: [private key path]
MySQL hostname: 127.0.0.1
MySQL port: 3306
password: [mysql user root password]
I’ve already tried switching the bind-address and the MySQL hostname to 0.0.0.0, but nothing changed. I also checked if port 3306 is occupied but that wasn’t the case.
Also at workbench server connection editor there are 2 extra tabs, Remote Management and System Profile. Do I have to do something there or should I choose, Do not use remote management?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.