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] [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/.grass8/dblogin (Unix-like systems)

    •   %APPDATA%\Roaming\GRASS8\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)

SOURCE CODE

Available at: db.login source code (history)

Accessed: Friday Apr 04 01:18:43 2025

Main index | Database index | Topics index | Keywords index | Graphical index | Full index

© 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual