Page 1 of 1

Connecting MySQL Workbench to Sonic

Posted: Wed Feb 25, 2015 10:48 am
by John M
I use MySQL Workbench to manage databases on various servers. MySQL Workbench runs on my local workstation. I have been trying unsuccessfully to connect to the MySQL server at Sonic. I am specifying port 3306 at the hostname that is provided by the member tools, and using the administration username and password for the database. The message returned says "Can't connect to MySQL server on 'sdogjm.db.sonic.net' (10060). I have double-checked the userid/password and other details, but can't seem to make this work.

Is Sonic using a port other than 3306? Does anybody have any thoughts on this?

Thanks in advance,
John

Re: Connecting MySQL Workbench to Sonic

Posted: Wed Feb 25, 2015 11:25 am
by sdogjm
Solved. MySQL Workbench has an option to connect using SSH. I used shell.sonic.net:22 as the SSH proxy (using my shell userid and password), and it made the connection!

Apparently Sonic does not permit connections to the database server from "outside" locations (even though I am connected with a sonic static ip address).

John

Re: Connecting MySQL Workbench to Sonic

Posted: Tue Mar 24, 2015 3:52 am
by chapai
Hi John,

do you use your sonic userid/password of it something specific for ssh?

Re: Connecting MySQL Workbench to Sonic

Posted: Tue Mar 24, 2015 9:32 am
by sdogjm
Yes, I use my sonic userid/pw to make the ssh connection to shell.sonic.net, then MySQL Workbench uses that tunnel to get to the database server.

J