如何查看Navicat已连接但本人忘记的mysql密码

查看密码

适用情况：已安装软件记录过密码，但本人忘记密码

参考文档：https://blog.51cto.com/u_13002884/5894541 、 https://blog.csdn.net/qq_43501821/article/details/126347953

在线代码运行网址：https://tool.lu/coderunner/ 

【提示】

代码没有错误，但2024/07/17我重新试了一下，原来的在线运行网址报错  PHP Warning: Trying to access array offset on value of type bool in /code/main.php on line 70  换了几个别的在线运行网站都报错：Fatal error: Uncaught Error: Call to undefined function openssl_decrypt() in /box/script.php:63 。搜索后发现 “在PHP中，OpenSSL扩展库是一个用于实现加密和解密功能的扩展, 用于安全通信。OpenSSL扩展库可以执行各种加密操作，如数据加密、解密、数字签名等。”而这个报错都指向 未开启openssl。但我用的本身就是在线运行php代码的网址，不需要配置环境，所以多试了几个网站，目前发现  在线Php编译器 - 即时运行Php代码 - toolfk 可以使用。遇到报错可以自己多试几个网站。

 

修改密码

参考文档：https://blog.csdn.net/dengdaijc/article/details/124882253

  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码'; 

---

 以下是我实操情况：

注册表查找  \HKEY_CURRENT_USER\SOFTWARE\PremiumSoft\navicat\servers 

 点击test，在右侧找到 Pwd

双击Pwd

 打开 https://tool.lu/coderunner/

 解密代码如下：

<?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('15057D7BA390');
$decode = $navicatPassword->decrypt('decrypt 这里填入你的Pwd的数值数据');
echo $decode."\n";
?>

运行结果：