I have a concern regarding CocoaMySQL and ssh tunnel. For the record I
have been able to connect to a mysql server via a remote ssh tunnel using
CocoaMySQL. However this case presents an obstacle for which I am at a
loss in negotiating.
I have deduced the remote mysqld connect failure to be attributed by the
fact that the remote mysql server is utilizing the "skip-networking" option
in "my.cnf". It is stated in the mysql documentation that this option
restricts mysqld from using the network stack--no tcp port for network
connections. As such, I am forced to talk to the mysqld via a unix socket
file.
- I have tried creating the ssh tunnel leaving the remote port designation
blank--to no avail.
- I also tried entering the location of the remote mysql.socket file into the
"socket *" field within the CocoaMySQL connection window--to no avail.
CocoaMySQL seemed to be trying to look in my filesystem for the location
of mysql.socket. I suspect some limitation within ssh local port
forwarding.
That being said, I am not sure if a CocoaMySQL connection via ssh tunnel
is possible at all under this particular scenario. Omitting "skip-
networking" is currently not an option.
I am using CocoaMySQL 0.7b4 on OS X 10.4.7 (8J135). The remote mysql
server is running MySQL 3.23.58.
Best Regards