Steve Leibel <[EMAIL PROTECTED]> wrote: > Hello, I'm new to this list so I hope this is the right type of > question that can be asked. > > At work I have access to a particular database only from a particular > host, say X. I would like to write a little script to view the data. > The script would be running on host Y. Is it possible to somehow get > a program running on host Y to get access to the database? > > As a limiting case, I could write code that runs on host Y and > establishes a telnet session to host X, then runs the mysql client > and accesses the database like that. > > What I'm wondering is if there is a cleaner and simpler way, for > example to set up some sort of proxy server on host X that will > establish a connection with the mysql database and then relay > requests and responses back and forth to my code on host Y.
You may want to use ssh port forwarding. Like, say, try that on Y: ssh -L 3307:database_host:3306 X Then connect to localhost port 3307. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]