[GRASSLIST:5018] Re: latest 5.7-cvs can't connect to MySQL

[Radim Blazek]

Use db.login:
http://grass.itc.it/pipermail/grassuser/2004-November/027074.html

Radim

Dylan Beaudette wrote:
> Hi everyone,
> 
> I just noticed that I can no longer connect to my MySQL tables from within 
> GRASS 5.7-cvs..
> 
> before I could execute:
> db.connect driver=mysql 
> database="host=localhost,dbname=test,user=xxxx,password=xxxx"
> 
> and i could then work with tables in MySQL...
> 
> now, even after setting the connection parameters with db.connect, i get the 
> following errors when executing `db.tables -p`:
> 
> -------------error messages-------------
> db.tables -p
> WARNING: 'user' in database definition is not supported, use db.connect
> WARNING: 'password' in database definition is not supported, use db.connect
> DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access denied for 
> user: 'dylan at localhost' (Using password: NO)
> ------------------------------------------------
> 
> and the following shows up in mysql.log
> ----------mysql.log------------
> Access denied for user: 'dylan at localhost' (Using password: NO)
> ----------------------------------
> 
> ...somehow GRASS 5.7-cvs from last month was able to connect to mysql, but the 
> latest one is having problems passing some parameters (username and password) 
> to mysql
> 
> any ideas?
> 
> thanks in advance
> 
>