<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>GRASS GIS: db.login</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="grassdocs.css" type="text/css"> </head> <body bgcolor="white"> <img src="grass_logo.png" alt="GRASS logo"><hr align=center size=6 noshade> <h2>NAME</h2> <em><b>db.login</b></em> - Sets user/password for driver/database. <h2>KEYWORDS</h2> database, SQL <h2>SYNOPSIS</h2> <b>db.login</b><br> <b>db.login help</b><br> <b>db.login</b> <b>driver</b>=<em>name</em> <b>database</b>=<em>name</em> [<b>user</b>=<em>string</em>] [<b>password</b>=<em>string</em>] [--<b>verbose</b>] [--<b>quiet</b>] <h3>Parameters:</h3> <DL> <DT><b>driver</b>=<em>name</em></DT> <DD>Driver name</DD> <DD>Default: <em>dbf</em></DD> <DT><b>database</b>=<em>name</em></DT> <DD>Database name</DD> <DD>Default: <em>$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/</em></DD> <DT><b>user</b>=<em>string</em></DT> <DD>Username</DD> <DT><b>password</b>=<em>string</em></DT> <DD>Password</DD> </DL> <h2>DESCRIPTION</h2> <em>db.login</em> sets user/password for driver/database. <h2>NOTE</h2> This is only related to SQL database backends (PostgreSQL, MySQL etc). The passwords are stored in a hidden file in the user account ('home' directory) called <em>.grasslogin6</em>. Only the file owner can access this file. <h2>EXAMPLES</h2> Example 1: Username specified, password will be invisibly queried interactively: <div class="code"><pre> db.login user=bacava </pre></div> <P> Example 2: Username and password specified (note that the command lines history will store the password in this way): <div class="code"><pre> db.login user=bacava pass=secret </pre></div> <P> Example 3: Username and empty password specified (note that the command lines history will store the password in this way): <div class="code"><pre> db.login user=bacava pass="" </pre></div> <h2>SEE ALSO</h2> <em> <a HREF="db.connect.html">db.connect</a>, <a HREF="db.test.html">db.test</a> </em> <h2>AUTHOR</h2> Radim Blazek <p><i>Last changed: $Date: 2007-11-29 14:21:10 +0100 (Thu, 29 Nov 2007) $</i> <HR> <P><a href="index.html">Main index</a> - <a href="database.html">database index</a> - <a href="full_index.html">Full index</a></P> <P>© 2003-2008 <a href="http://grass.osgeo.org">GRASS Development Team</a></p> </body> </html>