SSH, SCP connections to remote MySQL Database using OpenOffice Possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



I'm trying to find a way to get remote connections from my Linux Desktop machine to a remote Linux box which is hosting a MySQL database, via SSH port 22, and then once connection is established, log in to the database port 3306 and have either an SSH and or SCP connection established so I can securely do edits and queries.

I am able to connect this way from my Windows machine to remote server using Navicat. Both the windows desktop and the server are set up this way. I just can't figure out how to get my Linux desktop and the remote Linux box to talk this way.

I can connect to the remote database via Linux desktop, it's just via an un encrypted connection through port 3306. For obvious reasons I don't want to do it that way.

I tried connecting to the remote database in the same way I use Konqueror for FTP over SSH, i.e., by connecting via the fish protocol over port 22 -by enterning into OpenOffice Base for the server URL: fish://user@xxxxxxxxxxxxxxxx:22 and the error that comes up in either OO Base or Calc said I must specify a port number after the : , which I did, and it still won't connect that way.

My question is, is OpenOffice Calc able to connect to remote databases via SSH and or SCP? If so, do I need a plug in for that, or need to configure calc to do that in some way? How would I do this, or which plug in(s) do I need?

_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux