Allow MariaDB/mysql password from .pgpass instead of mandatory hard-coding in the user mapping

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL

Other

521 stars 160 forks source link

Allow MariaDB/mysql password from .pgpass instead of mandatory hard-coding in the user mapping #253

Open d-maumary opened 2 years ago

d-maumary commented 2 years ago

Currently the mysql/MariaDB password has to be set as part of the user mapping in the database. In postgres_fdw the password is picked up from .pgpass file if missing. It would be nice to have the same feature here.

requires option "password_required" (currently invalid)

surajkharage19 commented 2 years ago

Thanks. We will surely check how we can achieve similar functionality in mysql_fdw. Thanks again for your interest.