Provided by: grass-doc_7.4.0-1_all
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
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=""
SEE ALSO
db.connect, db.test, db.tables SQL support in GRASS GIS
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 23:06:38 +0200 (Thu, 01 Oct 2015) $
SOURCE CODE
Available at: db.login source code (history) Main index | Database index | Topics index | Keywords index | Graphical index | Full index © 2003-2018 GRASS Development Team, GRASS GIS 7.4.0 Reference Manual