db.login(1grass) GRASS GIS User's Manual db.login(1grass)
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] [pass-
word=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 data-
base 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 Techni-
cal University in Prague, Czech Republic (GRASS 7.1)
SOURCE CODE
Available at: db.login source code (history)
Accessed: unknown
Main index | Database index | Topics index | Keywords index | Graphical
index | Full index
© 2003-2022 GRASS Development Team, GRASS GIS 7.8.7 Reference Manual
GRASS 7.8.7 db.login(1grass)
Generated by dwww version 1.14 on Sat Jun 13 09:44:07 CEST 2026.