---
name: "db.login"
section: "1grass"
platform: "linux"
package: "grass-doc"
version: "8.4.1-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/db.login"
---

# db.login(1grass)

Sets user/password for DB driver/database.

## 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: Monday Feb 24 17:50:22 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