Howto store a password for jdbc-connection?
Posted: Wed Sep 17, 2008 2:07 pm
In my setup openoffice is acting as a front end for a mysql database. Every time I log in to a openoffice database, i have to fill in the password for the Mysql-database. That is ok because the mysql database is password is protected and i like to keep it that way. But i would like openoffice to remember the password, so i don't have to type it every time I login.
It is not an option to disable the password in Mysql, because sometimes i need to connect to the database over the internet and that is why it has a strong password. (that also a reason why it is annoying to type it in very often). As far as i can see there is no gui where you can make openoffice remember the password. It only can remember it for the session and remember the username.
Maybe there is some configuration file i can edit the connection string for my database so it doesn't pop up for my password. Or maybe there is some password manager for openoffice, similar to thunderbird? Any help would be appreciated.
It is not an option to disable the password in Mysql, because sometimes i need to connect to the database over the internet and that is why it has a strong password. (that also a reason why it is annoying to type it in very often). As far as i can see there is no gui where you can make openoffice remember the password. It only can remember it for the session and remember the username.
Maybe there is some configuration file i can edit the connection string for my database so it doesn't pop up for my password. Or maybe there is some password manager for openoffice, similar to thunderbird? Any help would be appreciated.