Navicat获取数据库连接密码

1.打开navicat，点击【文件】-》【导出连接】，选择需要的连接，点击下面【导出密码】，打开导出的文件里面有Password字段，这个值是加密的

1.打开navicat，点击【文件】-》【导出连接】，选择需要的连接，点击下面【导出密码】，打开导出的文件里面有Password字段，这个值是加密的

2.

打开这个网站

https://tool.lu/coderunner，复制下面代码到左边输入框，从步骤1获取到的加密的密码，复制到【在此处粘贴复制出来的密码】处；如果解析的密码乱码，切换11或者12 版本号

<?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(11);

$navicatPassword = new NavicatPassword(11);

//解密

//$decode = $navicatPassword->decrypt('15057D7BA390');

$decode = $navicatPassword->decrypt('在此处粘贴复制出来的密码');

echo $decode."n";

?>