Bug #88809 Standard TCP/IP over SSH error
Submitted: 7 Dec 2017 10:07 Modified: 7 Dec 2017 23:16
Reporter: Mario De Nisi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.10 OS:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[7 Dec 2017 10:07] Mario De Nisi
Description:
12:59:16 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.10 CE build 12092614 (64 bit)
	Configuration Directory: C:\Users\u06586\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro
	CPU: 4x Intel(R) Core(TM) i5-6200U CPU @ 2.30GHz, 15.9 GiB RAM
	Active video adapter Intel(R) HD Graphics 520
	Installed video RAM: 1024 MB
	Current video mode: 1366 x 768 x 4294967296 colori
	Used bit depth: 32
	Driver version: 21.20.16.4590
	Installed display drivers: igdumdim64,igd10iumd64,igd10iumd64,igd12umd64,igdumdim32,igd10iumd32,igd10iumd32,igd12umd32
	Current user language: Italiano (Italia)

12:59:16 [INF][      Workbench]: UI is up
12:59:17 [INF][      Workbench]: Running the application
12:59:19 [INF][     SSH tunnel]: Starting tunnel
12:59:19 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
12:59:23 [INF][     SSH tunnel]: Opening SSH tunnel to 10.192.43.105:22
12:59:33 [INF][     SSH tunnel]: TunnelManager.wait_connection returned OK
12:59:33 [INF][     SSH tunnel]: SSH tunnel connect executed OK
12:59:39 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
12:59:39 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: NO)
12:59:45 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [WRN][SQL Editor Form]: Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [ERR][SQL Editor Form]: Connection failed but remote admin does not seem to be available, rethrowing exception...
12:59:45 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [ERR][    WQE backend]: Got an exception during connection: Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [ERR][SQL Editor Form]: SQL editor could not be connected: Can't connect to MySQL server on '127.0.0.1' (10061)
12:59:45 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' from your host to server at localhost:3306:
  Can't connect to MySQL server on '127.0.0.1' (10061)

Please:
1 Check that mysql is running on server localhost
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to localhost from your address (mysql rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
13:03:23 [INF][      Workbench]: Shutting down Workbench
13:03:23 [INF][ mforms managed]: Shutting down mforms wrapper
13:03:23 [INF][      Workbench]: Done

How to repeat:
Select new connection Standard TCP/IP over SSH:

Set ssh hostname to <ip remote machine>:22
Set ssh username (a valid username for the remote machine)
Set MySQL hostname to 127.0.0.1
Set MySQL Server port to 3306
Set Username (a valid username for MySQL - as usual "root")

-------

Lunch the connection just defined. Insert password for ssh username (OK).
Insert password for username root of MySQL in localhost.

You get the error.
[7 Dec 2017 23:14] Miguel Solorzano
Connection works

Attachment: over-ssh.png (image/png, text), 182.23 KiB.

[7 Dec 2017 23:16] Miguel Solorzano
Thank you for tye bug report. Please see prior attached screen-shot.