Re: simple select from another server

[brian pribis]

I realize you are looking for an easy way to do this, but the way I've always done it (and I believe the most secure) is to create a user on the remote db with the specific privileges needed (and if possible restricted to a specific IP address), Then log in remotely using mysql -u user_name -p -h [ip of remote host]

You are right, I can't imagine being able to connect via a SQL query from another database is very secure. In fact, it would seem the trade off between convenience and parsing the query for remote access plus the security issues would be worth it.


brian