Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.
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, 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
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.
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.
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=""
db.connect,
db.test,
db.tables
SQL support in GRASS GIS
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)
Latest change: Monday Nov 18 20:15:32 2019 in commit: 1a1d107e4f6e1b846f9841c2c6fabf015c5f720d
Main index |
Database index |
Topics index |
Keywords index |
Graphical index |
Full index
© 2003-2023
GRASS Development Team,
GRASS GIS 7.8.9dev Reference Manual