Navicat 查看密码方案
解决问题:
我们经常使用 navicat 连接数据库,有时候时间久了之后,会忘记之前的密码,那么现在我们有办法获得只要正常连接的数据库的密码
步骤:
- 导出连接 connections.ncx,拿到保存到本地的 connections.ncx 文件中的 Password,粘贴到下面的代码中
- 登陆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?>
- 点击执行之后,就会得到真实密码