[Feature request] my.cnf as user credential store

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL

Other

521 stars 160 forks source link

[Feature request] my.cnf as user credential store #279

Open mmonschau opened 11 months ago

mmonschau commented 11 months ago

Hi,

I'd like to store the mysql-credentials in my ~/.my.cnf on my postgres-host, so those are't included in my nightly backups in plain text.

surajkharage19 commented 11 months ago

Thanks for your request.

Currently, we do not have such functionality. It seems MySQL library has some options (MYSQL_READ_DEFAULT_FILE in mysql_options() API) using which we can achieve the same. Currently this is not on our roadmap but we will surely think on the same in the future.