如何查看Navicat已连接数据库的密码

0、步骤概览

1. 注册表找到加密后的密码字符串
2. 在线代码工具运行代码解密获得原密码字符串

1、注册表找到加密后的密码字符串

1. 快捷键win + r，输入regedit打开注册表

2. 目录\HKEY_CURRENT_USER\SOFTWARE\PremiumSoft\navicat\servers找到对应的数据库连接

3. 找到key为pwd的值（加密后的密码字符串）

   

2、在线代码工具运行代码解密获得原密码字符串

1. 编程语言：php，在线编码地址：https://tool.lu/coderunner/

2. 复制下面解密代码到【在线编码】中，修改倒数第二行代码，将上面的pwd的值写入decrypt(’’);中，点击运行即可获得解密后的密码。

3. 解密代码

   <?php
   class NavicatPassword
   {
       protected $version = 0;
       protected $aesKey = 'libcckeylibcckey';
       protected $aesIv = 'libcciv libcciv ';
       protected $blowString = '3DC5CA39';
       protected $blowKey = null;
       protected $blowIv = null;
   
       public function __construct($version = 12)
       {
           $this->version = $version;
           $this->blowKey = sha1('3DC5CA39', true);
           $this->blowIv = hex2bin('d9c7c3c8870d64bd');
       }
   
       public function encrypt($string)
       {
           $result = FALSE;
           switch ($this->version) {
               case 11:
                   $result = $this->encryptEleven($string);
                   break;
               case 12:
                   $result = $this->encryptTwelve($string);
                   break;
               default:
                   break;
           }
   
           return $result;
       }
   
       protected function encryptEleven($string)
       {
           $round = intval(floor(strlen($string) / 8));
           $leftLength = strlen($string) % 8;
           $result = '';
           $currentVector = $this->blowIv;
   
           for ($i = 0; $i < $round; $i++) {
               $temp = $this->encryptBlock($this->xorBytes(substr($string, 8 * $i, 8), $currentVector));
               $currentVector = $this->xorBytes($currentVector, $temp);
               $result .= $temp;
           }
   
           if ($leftLength) {
               $currentVector = $this->encryptBlock($currentVector);
               $result .= $this->xorBytes(substr($string, 8 * $i, $leftLength), $currentVector);
           }
   
           return strtoupper(bin2hex($result));
       }
   
       protected function encryptBlock($block)
       {
           return openssl_encrypt($block, 'BF-ECB', $this->blowKey, OPENSSL_RAW_DATA|OPENSSL_NO_PADDING);
       }
   
       protected function decryptBlock($block)
       {
           return openssl_decrypt($block, 'BF-ECB', $this->blowKey, OPENSSL_RAW_DATA|OPENSSL_NO_PADDING);
       }
   
       protected function xorBytes($str1, $str2)
       {
           $result = '';
           for ($i = 0; $i < strlen($str1); $i++) {
               $result .= chr(ord($str1[$i]) ^ ord($str2[$i]));
           }
   
           return $result;
       }
   
       protected function encryptTwelve($string)
       {
           $result = openssl_encrypt($string, 'AES-128-CBC', $this->aesKey, OPENSSL_RAW_DATA, $this->aesIv);
           return strtoupper(bin2hex($result));
       }
   
       public function decrypt($string)
       {
           $result = FALSE;
           switch ($this->version) {
               case 11:
                   $result = $this->decryptEleven($string);
                   break;
               case 12:
                   $result = $this->decryptTwelve($string);
                   break;
               default:
                   break;
           }
   
           return $result;
       }
   
       protected function decryptEleven($upperString)
       {
           $string = hex2bin(strtolower($upperString));
   
           $round = intval(floor(strlen($string) / 8));
           $leftLength = strlen($string) % 8;
           $result = '';
           $currentVector = $this->blowIv;
   
           for ($i = 0; $i < $round; $i++) {
               $encryptedBlock = substr($string, 8 * $i, 8);
               $temp = $this->xorBytes($this->decryptBlock($encryptedBlock), $currentVector);
               $currentVector = $this->xorBytes($currentVector, $encryptedBlock);
               $result .= $temp;
           }
   
           if ($leftLength) {
               $currentVector = $this->encryptBlock($currentVector);
               $result .= $this->xorBytes(substr($string, 8 * $i, $leftLength), $currentVector);
           }
   
           return $result;
       }
   
       protected function decryptTwelve($upperString)
       {
           $string = hex2bin(strtolower($upperString));
           return openssl_decrypt($string, 'AES-128-CBC', $this->aesKey, OPENSSL_RAW_DATA, $this->aesIv);
       }
   };
   
   
   //需要指定版本两种，11或12
   //$navicatPassword = new NavicatPassword(12);
   $navicatPassword = new NavicatPassword(11);
   
   //解密
   $decode = $navicatPassword->decrypt('5658213B');
   echo $decode."\n";
   ?>
   

   

3、参考

1. 如何查看navicat已连接用户的密码