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.