connecting [logging] RMySQL to an external server - SOLVED
Hi James,
On Wednesday 19 December 2007, David James wrote:
Hi, I'm sorry I'm also coming late to this discussion, but like Dirk, I fail to understand what's wrong with using dbConnect() the way the documentation, (see ?MySQL) suggests. RMySQL was developed in a fully distributed client/server environment, and it uses the MySQL-provided client API. The options that the MySQL client library allows (user, password, host, port or socket file, compression, etc.) should work from RMySQL (RMySQL just passes those directly to the MySQL client library). If you have a specific (e.g., security-related) need that the MySQL client API does not address, then the use of ssh may be the proper way to go. But for simple, vanilla style of client-server communications the underlying MySQL client should be sufficient.
Normally yes, you are right, but this particular MySQL server does not allow remote connections (it does not directly listens to port 3306) but only local connections using a socket (this terminology is unfamiliar to me, I may talk stupid). So I have to first create a secure login and only after that connect to the remote MySQL server. I hope my situation is more clear now, Adrian
Adrian Dusa
Romanian Social Data Archive
1, Schitu Magureanu Bd
050025 Bucharest sector 5
Romania
Tel./Fax: +40 21 3126618 \
+40 21 3120210 / int.101