prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.97k stars 5.35k forks source link

how to hide or encrypt the password in catalog properties file #14702

Open gomou opened 4 years ago

gomou commented 4 years ago

I configure the mysql connector in a catalog properties file like that: connector.name=mysql connection-url=jdbc:mysql://example.net:3306 connection-user=root connection-password=secret but I hope the "secret" is encrypted or invisible if I use MD5 to encrypt this passsword, how presto decrypt it thanks

mbasmanova commented 4 years ago

I don't believe this is supported out of the box, but this post might be helpful: https://blog.starburstdata.com/technical-blog/starburst-secrets-presto-security