GRASS GIS manual: db.login

Note: A new GRASS GIS stable version has been released: GRASS GIS 7.6, available here.
Updated manual page: here

NAME

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

KEYWORDS

database, connection settings

SYNOPSIS

db.login

db.login --help

db.login [-p] driver=name database=name [user=string] [password=string] [host=string] [port=string] [--overwrite] [--help] [--verbose] [--quiet] [--ui]

Flags:

-p: Print connection settings and exit
--overwrite: Allow output files to overwrite existing files
--help: Print usage summary
--verbose: Verbose module output
--quiet: Quiet module output
--ui: Force launching GUI dialog

Parameters:

driver=name [required]: Name of database driver; Options: dbf, mysql, odbc, ogr, pg, sqlite; Default: sqlite
database=name [required]: Name of database; Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
user=string: Username
password=string: Password
host=string: Hostname; Relevant only for pg and mysql driver
port=string: Port; Relevant only for pg and mysql driver

DESCRIPTION
NOTE
EXAMPLES
SEE ALSO
AUTHOR

DESCRIPTION

db.login sets login parameters such an user name and optionally also a password, a hostname or a port for the connection to the selected database through the DB driver.

NOTE

Options host and port are related to only SQL database backends like PostgreSQL, MySQL or ODBC.

Note that the passwords are stored in a hidden, unencrypted file in the user account, specifically

in the 'home' directory, i.e. $HOME/.grass7/dblogin (Unix-like systems)
%APPDATA%/GRASS7/dblogin (MS-Windows)

Only the file owner can access this file.

EXAMPLES

Only username specified (assuming locally accessible PostgreSQL DB without password):

db.login driver=pg database=mydb

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

db.login driver=pg database=mydb user=bacava password=secret host=db.example.com

Username and empty password specified:

db.login driver=pg database=mydb user=bacava password=""

AUTHOR

Radim Blazek
Support for hostname and port by Martin Landa, OSGeoREL, Czech Technical University in Prague, Czech Republic (GRASS 7.1)

Last changed: $Date: 2015-10-01 14:06:38 -0700 (Thu, 01 Oct 2015) $

SOURCE CODE

Available at: db.login source code (history)