MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. The Object Browser provides instant access to database schema and objects. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric.
The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. These two version works with Debian Wheezy but not with Debian Jessie.MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. I have tried two different version of MySQL Workbench: Version 6.3.3.0 build 592 (64 bits) I can connect with SSH (KiTTY) on both server. Pkts bytes target prot opt in out source destinationĬhain FORWARD (policy ACCEPT 0 packets, 0 bytes)Ĭhain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
The folder "ssh" is not present in: C:\Users\myUser\AppData\Roaming\MySQL\Workbenchįirewall rules on both servers: iptables -vnLĬhain INPUT (policy ACCEPT 0 packets, 0 bytes) SSHException: Incompatible ssh peer (no acceptable kex algorithm)ġ0:00:07 : TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for detailsġ0:00:07 : Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details Look_for_keys=has_key, allow_agent=has_key)įile "C:\Program Files\MySQL\MySQL Workbench 6.3 CE/python/site-packages\paramiko\client.py", line 301, in connectįile "C:\Program Files\MySQL\MySQL Workbench 6.3 CE/python/site-packages\paramiko\transport.py", line 461, in start_client The log file: 10:00:04 : Starting tunnelġ0:00:04 : Existing SSH tunnel not found, opening new oneġ0:00:07 : Opening SSH tunnel to 10.232.50.15:22ġ0:00:07 : IOError, probably caused by file C:\Users\myUser\AppData\Roaming\MySQL\Workbench\ssh\known_hosts not found, the message was: No such file or directory: u'C:\\Users\\myUser\\AppData\\Roaming\\MySQL\\Workbench\\ssh\\known_hosts'ġ0:00:07 : Traceback (most recent call last):įile "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\sshtunnel.py", line 297, in _connect_ssh The error MySQL Workbench 6.3.3 give me when I try to connect to the Debian Jessie server: Could not connect the SSH TunnelĪuthentication error, unhandled exception caught in tunnel manager, please refer to logs for details So the man difference is the ServerKeyBits between the two sshd_config file. Subsystem sftp /usr/lib/openssh/sftp-serverĭebian Jessie server cat /etc/debian_version 8.0 Mysql> select version() +-+ġ row in set (0.00 cat /etc/ssh/sshd_config Port 22 I have double check the IP address/hostname, username and password.ĭebian Wheezy server cat /etc/debian_version 7.8 MySQL Workbench config: Connection Name: TESTĬonnection Method: Standard TCP/IP over SSH
#Mysql workbench 6.3 download 64 bit pro#
I use to connect with Windows 7 Pro 圆4 to my MySQL server hosted on a Debian Wheezy with the MySQL Workbench client using the "TCP/IP over SSH" but it does not work on my new server on Debian Jessie, why ?
0 kommentar(er)
