Remember ODBC MySQL Password

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Remember ODBC MySQL Password

Postby lachieg » Mon Jul 13, 2015 8:34 am

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

Open Office Base 4.1.1 on Windows XP and 7
Posts: 1
Joined: Mon Jul 13, 2015 8:32 am

Re: Remember ODBC MySQL Password

Postby Villeroy » Mon Jul 13, 2015 9:43 am

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   Expand viewCollapse view
oDS = ThisComponent.DataSource
oDS.User = "Edward Snowden"
oDS.Password = "T0p_S3cr3t"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28666
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests