How to get Dbeaver credentials/password

At the time of writing this is only tested for Dbeaver 21.1.4.

Sometimes you may want to obtain database password without nagging your DBA. Here is how.

1. Have openssl command installed/accessible
2. Open your terminal
3. Locate the credentials file (credentials-config.json)
   1. Windows: (please comment!)
   2. Mac OS: ~/Library/DBeaverData/workspace6/General/.dbeaver/
   3. Linux: (please comment!)
4. Enter this command:
   openssl aes-128-cbc -d -K babb4a9f774ab853c96c2d653dfe544a -iv 00000000000000000000000000000000 -in credentials-config.json | dd bs=1 skip=16 2>/dev/null

And thats it!

References:

1. https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection
2. https://programmersought.com/article/70608329126/

Comments

comments