Navicat 查看导出连接的密码 | navicat查看密码方案

本页内容

Navicat 查看密码方案

解决问题:

我们经常使用 navicat 连接数据库,有时候时间久了之后,会忘记之前的密码,那么现在我们有办法获得只要正常连接的数据库的密码

步骤:

  1. 导出连接 connections.ncx,拿到保存到本地的 connections.ncx 文件中的 Password,粘贴到下面的代码中
  2. 登陆https://tool.lu/coderunner/,使用 PHP 在线运行工具,粘贴下面添加密码后的代码
    备用工具网址(https://zixuephp.net/tool-runcode.html)
  1<?php
  2class NavicatPassword
  3{
  4    protected $version = 0;
  5    protected $aesKey = 'libcckeylibcckey';
  6    protected $aesIv = 'libcciv libcciv ';
  7    protected $blowString = '3DC5CA39';
  8    protected $blowKey = null;
  9    protected $blowIv = null;
 10
 11    public function __construct($version = 12)
 12    {
 13        $this->version = $version;
 14        $this->blowKey = sha1('3DC5CA39', true);
 15        $this->blowIv = hex2bin('d9c7c3c8870d64bd');
 16    }
 17
 18    public function encrypt($string)
 19    {
 20        $result = FALSE;
 21        switch ($this->version) {
 22            case 11:
 23                $result = $this->encryptEleven($string);
 24                break;
 25            case 12:
 26                $result = $this->encryptTwelve($string);
 27                break;
 28            default:
 29                break;
 30        }
 31
 32        return $result;
 33    }
 34
 35    protected function encryptEleven($string)
 36    {
 37        $round = intval(floor(strlen($string) / 8));
 38        $leftLength = strlen($string) % 8;
 39        $result = '';
 40        $currentVector = $this->blowIv;
 41
 42        for ($i = 0; $i < $round; $i++) {
 43            $temp = $this->encryptBlock($this->xorBytes(substr($string, 8 * $i, 8), $currentVector));
 44            $currentVector = $this->xorBytes($currentVector, $temp);
 45            $result .= $temp;
 46        }
 47
 48        if ($leftLength) {
 49            $currentVector = $this->encryptBlock($currentVector);
 50            $result .= $this->xorBytes(substr($string, 8 * $i, $leftLength), $currentVector);
 51        }
 52
 53        return strtoupper(bin2hex($result));
 54    }
 55
 56    protected function encryptBlock($block)
 57    {
 58        return openssl_encrypt($block, 'BF-ECB', $this->blowKey, OPENSSL_RAW_DATA|OPENSSL_NO_PADDING);
 59    }
 60
 61    protected function decryptBlock($block)
 62    {
 63        return openssl_decrypt($block, 'BF-ECB', $this->blowKey, OPENSSL_RAW_DATA|OPENSSL_NO_PADDING);
 64    }
 65
 66    protected function xorBytes($str1, $str2)
 67    {
 68        $result = '';
 69        for ($i = 0; $i < strlen($str1); $i++) {
 70            $result .= chr(ord($str1[$i]) ^ ord($str2[$i]));
 71        }
 72
 73        return $result;
 74    }
 75
 76    protected function encryptTwelve($string)
 77    {
 78        $result = openssl_encrypt($string, 'AES-128-CBC', $this->aesKey, OPENSSL_RAW_DATA, $this->aesIv);
 79        return strtoupper(bin2hex($result));
 80    }
 81
 82    public function decrypt($string)
 83    {
 84        $result = FALSE;
 85        switch ($this->version) {
 86            case 11:
 87                $result = $this->decryptEleven($string);
 88                break;
 89            case 12:
 90                $result = $this->decryptTwelve($string);
 91                break;
 92            default:
 93                break;
 94        }
 95
 96        return $result;
 97    }
 98
 99    protected function decryptEleven($upperString)
100    {
101        $string = hex2bin(strtolower($upperString));
102
103        $round = intval(floor(strlen($string) / 8));
104        $leftLength = strlen($string) % 8;
105        $result = '';
106        $currentVector = $this->blowIv;
107
108        for ($i = 0; $i < $round; $i++) {
109            $encryptedBlock = substr($string, 8 * $i, 8);
110            $temp = $this->xorBytes($this->decryptBlock($encryptedBlock), $currentVector);
111            $currentVector = $this->xorBytes($currentVector, $encryptedBlock);
112            $result .= $temp;
113        }
114
115        if ($leftLength) {
116            $currentVector = $this->encryptBlock($currentVector);
117            $result .= $this->xorBytes(substr($string, 8 * $i, $leftLength), $currentVector);
118        }
119
120        return $result;
121    }
122
123    protected function decryptTwelve($upperString)
124    {
125        $string = hex2bin(strtolower($upperString));
126        return openssl_decrypt($string, 'AES-128-CBC', $this->aesKey, OPENSSL_RAW_DATA, $this->aesIv);
127    }
128};
129
130
131//需要指定navacat版本两种,11或12
132$navicatPassword = new NavicatPassword(12);
133
134//解密,括号里面写入navicat加密后的密码
135$decode = $navicatPassword->decrypt('E75BF077AB8BAA3AC2D5');
136echo $decode."\n";
137?>
  1. 点击执行之后,就会得到真实密码