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

[Markus Neteler]

Rainer,

I have extended the mysql example in the db.connect
manual page (a local and a network example now).


Markus

On Wed, Mar 15, 2006 at 10:30:07AM +0200, Rainer M Krug wrote:
> 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