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.
- Have openssl command installed/accessible
- Open your terminal
- Locate the credentials file (credentials-config.json)
- Windows: (please comment!)
- Mac OS: ~/Library/DBeaverData/workspace6/General/.dbeaver/
- Linux: ~/.local/share/DBeaverData/workspace6/General/.dbeaver/credentials-config.json (thanks for @xraya4t comment)
- 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:
- https://stackoverflow.com/questions/39928401/recover-db-password-stored-in-my-dbeaver-connection
- https://programmersought.com/article/70608329126/
Thanks!
ReplyDeleteThe Linux location is: ~/.local/share/DBeaverData/workspace6/General/.dbeaver/credentials-config.json