ZConnection/mySQL remote acess step by step

[mskeels]

All,

I am more newbie than most I guess.

I have been searching for docs for this to no avail.

I need to know how to set up ZConnection in D7 for a remote (over the internet) connection to mySQL using SSH. Please supply explanation of how to determine hostname and how to specify using SSH for mySQL.

Also, how to ask for access to a remote mySQL database when talking to dbadmins........

Thanks,
Mark

[mdaems]

Concerning

how to ask for access to a remote mySQL database when talking to dbadmins

Just ask the admin of the remote database. Then a normal dbadmin should be able to tell you the hostname and port of the server along with username and password you should use to connect. You can verify this access by using the mysql command line tool (mysql -h<hostname or ip> -P<port> -u<username> -p<password>). When this works connections using zeoslib should work like a charm.

But you're also talking about SSH. And that's something completely different. When you only can access your database by using SSH it means you can't directly access the server over the network on it's own port. Then the only solution is SSH Port Forwarding, which makes a port available on your local machine that's connected to the mysql port on the remote server by a SSH tunnel. Please google 'SSH Port Forwarding' for details on this process.

Mark