Remember ODBC MySQL Password

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
lachieg
Posts: 1
Joined: Mon Jul 13, 2015 8:32 am

Remember ODBC MySQL Password

Post by lachieg »

Is it possible to have Open Office Base remember the username and password for a MySQL ODBC Connection?

Thanks,
Lachie
Open Office Base 4.1.1 on Windows XP and 7
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Remember ODBC MySQL Password

Post by Villeroy »

Yes, but then you could remove it from your MySQL-db as well. The password would be written into the Base document as clear text (XML).
This option is not implemented in the GUI but a simple macro can do the trick

Code: Select all

oDS = ThisComponent.DataSource
oDS.User = "Edward Snowden"
oDS.Password = "T0p_S3cr3t"
ThisComponent.store()
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply