Provided by: grass-doc_7.0.3-1build1_all bug

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]   [--help]
       [--verbose]  [--quiet]  [--ui]

   Flags:
       -p
           Print connection settings and exit

       --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: mysql, odbc, sqlite, pg, ogr, dbf
           Default: sqlite

       database=name [required]
           Name of database
           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

       user=string
           Username to set for DB connection

       password=string
           Password to set for DB connection

DESCRIPTION

       db.login sets login parameters such an user name and optionally also a  password  for  the
       connection to the selected database through the DB driver.

NOTE

       This command is only related to 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 and password specified (note that  the  command  lines  history  will  store  the
       password in this way):
       db.login user=bacava password=secret

       Username  and empty password specified (note that the command lines history will store the
       password in this way):
       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

       Last changed: $Date: 2015-10-01 23:15:07 +0200 (Thu, 01 Oct 2015) $

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

       © 2003-2016 GRASS Development Team, GRASS GIS 7.0.3 Reference Manual