[GRASSLIST:123] Re: Connecting to remote MySQL server

[Rainer M Krug]

Hi Stephan

thanks a million - it is working now.

db.connect driver=mysql 
database="host=ecolmod-mysql,dbname=renpatch_renosterbos"

is the right syntax

Rainer

Stephan Holl wrote:
> Hello Rainer,
> 
> On Wed, 15 Mar 2006 09:10:09 +0200 Rainer M Krug <rkrug at sun.ac.za>
> wrote:
> 
>> Hi
>>
>> I compiled GRASS 6.1 with MySQL support, and I have the option to 
>> connect to a MySQL database. But it seems that I can only connect to
>> a locam MySQL database, as in the db.connect, I didn't find any
>> parameter for host name which I could specify.
>>
>> Can I connect to a remote MySQL database (I guess I can...) and if
>> yes, how; where can I specify the host name of the MySQL server?
> 
> At least for Postgres is an example stated in the manual-page :
> see 
> 	g.manual db.connect
>  
> db.connect driver=pg
> database="host=myserver.itc.it,dbname=mydb,port=6666" 
> db.login user=myname pass=secret db.
> connect -p
> db.tables -p
> 
> You might check this out with mysql. (I cannot, since I do not have
> mysql running here).
> 
> Hope this helps.
> 
> 	Stephan
> 
> 


-- 
--
Rainer M. Krug, Dipl. Phys. (Germany), MSc Conservation Biology (UCT)

Department of Conservation Ecology
University of Stellenbosch
Matieland 7602
South Africa

Tel:        +27 - (0)72 808 2975 (w)
Fax:        +27 - (0)21 808 3304
Cell:        +27 - (0)83 9479 042

email:    RKrug at sun.ac.za
           Rainer at krugs.de