GRASS logo

NAME

db.login - Sets user/password for driver/database.

KEYWORDS

database, SQL

SYNOPSIS

db.login
db.login help
db.login driver=name database=name [user=string] [password=string] [--verbose] [--quiet]

Parameters:

driver=name
Driver name
Options: pg,odbc,mysql,ogr,dbf,sqlite
Default: dbf
database=name
Database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
user=string
Username
password=string
Password

DESCRIPTION

db.login sets user/password for driver/database.

NOTE

This is only related to SQL database backends (PostgreSQL, MySQL etc). The passwords are stored in a hidden file in the user account ('home' directory) called .grasslogin6. Only the file owner can access this file.

EXAMPLES

Example 1: Username specified, password will be invisibly queried interactively:
db.login user=bacava

Example 2: Username and password specified (note that the command lines history will store the password in this way):

db.login user=bacava pass=secret

Example 3: Username and empty password specified (note that the command lines history will store the password in this way):

db.login user=bacava pass=""

SEE ALSO

db.connect, db.test

AUTHOR

Radim Blazek

Last changed: $Date: 2007-11-29 05:21:43 -0800 (Thu, 29 Nov 2007) $


Main index - database index - Full index

© 2003-2010 GRASS Development Team