» Home » Info » Vex.FAQ » database login

database login

When connecting to userdb.vex.net using psql or mysql from the shell you may be prompted for your password. If you would prefer to save your password to a file in your home directory, the password prompt can be bypassed.

For PostgreSQL create the file .pgpass in your home directory. The file should contain a line (or lines) following the format:

hostname:port:database:username:password

(For other automatic PostgreSQL settings see the environment variables section of the PostgrSQL documentation.)

For MySQL create the file .my.cnf in your home directory. The file should contain, at least:

[client]
user=yourlogin
host=userdb.vex.net
password=yourpassword

It is IMPORTANT to remember to make sure these above files are not readable by anyone besides you. Make sure to chmod 600 them!

Document Actions