[SOLVED] Cannot connect with MySQL Workbench
I've searched the forum for hour and a half, couldn't find the right answer.
I have a Linode VPS with Ubuntu 11.4 installed. On my desktop I've installed MySQL Workbench on Ubuntu 12.4. When I try to connect to MySQL with MySQL Workbench I use the following data:
Connection Method: Standard TCP/IP over SSH
SSH Hostname, SSH username: values from "Lish via SSH" available on Linode Manager>Linodes>Remote Access.
SSH Password: the one set on "Lish via SSH Password" on Linode Manager
MySQL Hostname: 127.0.0.1
MySQL Port: 3306
MySQL User, MySQL password: used the same I use on phpMyAdmin.
Test connection gives me error: "Lost connection to MySQL server at 'reading initial communication packet', system error: 0"
So, I manage to connect to server (worked on my desktop terminal, too), but no luck connecting MySQL via MySQL Workbench.
Any advice?
Thanks in advance
1 Reply
The minute I've posted this, I tried using different port and succeeded.
Thank you for your time, and sorry again.