[SOLVED] Cannot connect with MySQL Workbench

Hi everybody,

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

Sorry everybody,

The minute I've posted this, I tried using different port and succeeded.

Thank you for your time, and sorry again.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct