Encrypt Proxysql Admin password in config file

Hi,

I would like to know if there are any workaround ways to encrypt admin and cluster plain text password in the proxysql config file.

Thank you
Chanakya

Please check this ourt ProxySQL-Admin 2.x: Encryption of Credential Information

Hi,

Above does encrypt proxysql-admin configuration but not the proxysql config.

Please suggest if there are ways to encrypt proxysql config itself.

Thank you

As Mughees mentioned above, you can only encrypt the admin config file. You cannot encrypt the configuration file, which is similar to many other tool’s configuration files. You need to work on system level to secure the file.

That said, for “workaround”, once ProxySQL is configured you can always remove the credentials from proxysql config file as they won’t be needed anymore as the configuration there after is read from proxysql.db. You can force the usage of config file by explicitly “proxysql –initial” or “load xyz from config” option to read from config and manually override the proxysql.db. Refer this.

Thanks.