GRASS logo

NAME

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

KEYWORDS

database, SQL

SYNOPSIS

db.login
db.login help
db.login driver=string database=string [user=string] [password=string]

Parameters:

driver=string
Driver name
Options: sqlite,ogr,pg,odbc,dbf,mysql
database=string
Database name
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 13:21:43 $


Main index - database index - Full index