[GRASSLIST:6349] Re: mysql attribute management in 6.1cvs

[William K]

No problems here (hi Lorenzo).  I think the problem, tho is the 
db.connect command used.  Things changed at some point, and the correct 
way to do a db connection now is (ie to mysql):

db.connect dr=mysql dat="host=localhost,dbname=yourdbname"
db.login user=somemysqluser pass=mysqluserpass


I've been using MySQL 4.1.x since the alpha days with no problems on OS 
10.3.


On Apr 6, 2005, at 10:04 AM, Lorenzo Moretti wrote:

> Chris wrote
>
>> I am trying to add layers to a new location in 6.1 (cvs) on Mac OSX. I
>> have successfully used mysql with 5.7 in the past, but am running into
>> some problems with this release.
>>
>> I tried connecting to mysql using db.connect/db.login, as recommended
>> in the documentation, but got the following:
>>
>> DBMI-MYSQL driver error: mysql_real_connect() error (1045): Access
>> denied for user: chris at localhost
>>
>> Despite the fact that I was using the correct login information. If I
>> go back and do things the old way, using db.connnect:
>>
>> db.connect database="dbname=florida_gis,user=chris" driver="mysql"
>>
>> I get the following warning:
>>
>> WARNING: 'user' in database definition is not supported, use db.login
>>
>> *yet* it lets me import layers without any problem, and the tables
>> appear in the database. I'm not sure, therefore, what is the proper
>> way to do this. Please advise.
>>
>> Thanks,
>> Chris
>
> There are problems with MySQL 4.1.x. Use MySQL 4.0.x 
> (http://www.mysql.org).
>
> Now in OSX work these drivers: dbf, mysql (tested with MySQL 4.0.x, 
> problems with 4.1.x), pg (tested with pgsql 7.4.x+PostGis 0.7.x, 
> tested with pgsql 8.x 
> http://www.druware.com/products/postgresql.html).
>
> There are problems con odbc driver.
> Grass under OSX is built with unixodbc support. UnixOdbc is a tool to 
> connect an application under darwin  (the unix base of OS X) to 
> external db source via driver. Without an ODBC driver unixodbc is 
> unuseful.  ODBC drivers are present for MySQL, for PostgreSQL (see 
> sites) and these driver HAVE TO BUILT with unixodbc support. Today 
> there are problems to connect grass to ODBC source under Mac OS X.
>

-----
William Kyngesburye <kyngchaos at charter.net>
http://webpages.charter.net/kyngchaos/

Theory of the Universe

There is a theory which states that if ever anyone discovers exactly 
what the universe is for and why it is here, it will instantly 
disappear and be replaced by something even more bizarrely 
inexplicable.  There is another theory which states that this has 
already happened.

-Hitchhiker's Guide to the Galaxy 2nd season intro
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 2565 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/grass-user/attachments/20050406/b770941d/attachment.bin