5

Cannot connect to MySQL through SSH tunnel with MySQL Workbench without compromising security

view full story
linux-howto

http://serverfault.com – I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key. The error message I keep getting from Workbench is: Failed to Connect to MySQL at localhost:3306 through SSH tunnel example.com:2222 with user root Lost connection to MySQL server at 'reading initial communication packet', system error: 0 After hours of exercising the trial-and-error method, I seem to have figured out that the problem was in /etc/ssh/sshd_config, at the config line (HowTos)

dayu's picture
Submitted by dayu on 10/31/2012 – Made popular on 10/31/2012

Stories similar to Cannot connect to MySQL through SSH tunnel with MySQL Workbench without compromising security

MySql - mysql-workbench problem 2 years 46 weeks ago

Hi Guys,

I am looking to use the mysql tool mysql-workbench to administer mysql.

I downloaded the latest version from the MySql website, the fedora rpm. I used rpm2tgz to create a slackware package. Install seemed to go okay.

When I tried to run the mysql-workbench tool I got the following message.

in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc... in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:

Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL serve

I am getting dependency package errors as .

root@osscube:/home/abdul/Downloads# dpkg -i mysql-workbench-gpl-5.2.47-1ubu1004-amd64.deb Selecting previously unselected package mysql-workbench-gpl. (Reading database ...

I have read this enter link description here and installed mysql-workbench-gpl-5.2.43-1ubu1204-i386.deb. When setting up a connection to the MySQL running on localhost or remotely, I get this error:

Connecting to MySQL server localhost...

Cannot start SSH tunnel manager

I'm not sure what else to install.

MySQL Workbech Wont Connect 2 years 46 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

I originally installed mySQL on OSX and it started fine. I was able to connect with mySQL workbench and create a database. However, after a reboot mySQL will no longer start.

I've just installed MySQL workbench on my computer and have importend an old database into the system which seems to be working find. All the data is there and tables. I can do select, insert, updates etc.

However, if I expand a database, I see tables, views, routines. If I then right click on tables, nothing happens if I click create table...

MySQL Workbench 一直以来被认为替代 MySQL Administrator tools 的首选工具。今天，MySQL Workbench 团队发布了 5.2.25 版本。此版本与早前的 RC 版本不同，在于其是 GA 版本，是正式版本。

I'm trying to install mysql-workbench-gpl-5.2.45 from the source code on Linux debian 2.6.32-5-amd64.