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: ~/.local/share/DBeaverData/workspace6/General/.dbeaver/credentials-config.json (thanks for @xraya4t 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

  1. Thanks!

    The Linux location is: ~/.local/share/DBeaverData/workspace6/General/.dbeaver/credentials-config.json

    ReplyDelete

Post a Comment