ZConnection/mySQL remote acess step by step

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

mskeels
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 11.12.2008, 18:18

ZConnection/mySQL remote acess step by step

Postby mskeels » 18.11.2011, 02:38

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

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 17.12.2011, 21:30

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
Image


Return to “MySQL”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest