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

2024-06-04 13:45| 来源: 网络整理| 查看: 265

此教程的背景：数据库密码忘记了，但是在Navicat连接过且目前能连接上的状态！

1.导出数据库连接 connections.ncx 文件

选择你要导出密码的数据库连接，切记要勾上导出密码

2.使用文本编辑工具打开导出的connections.ncx 文件

找到Password=""，将双引号中间的密码复制出来使用下面的Java程序或PHP程序进行解密！

3.使用Java程序进行解密

Java在线运行环境：代码在线运行 - 在线工具，进入选择Java即可！将以下代码复制到在线运行环境中并把代码中的密码替换为你自己connections.ncx文件中的密码运行即可！

import javax.crypto.Cipher; import javax.crypto.spec.IvParameterSpec; import javax.crypto.spec.SecretKeySpec; import java.security.MessageDigest; import java.util.Arrays; /** * 以下程序均为ChatGPT生成 * @Author: 木芒果 */ public class NavicatPassword { public static void main(String[] args) throws Exception { NavicatPassword navicatPassword = new NavicatPassword(); // 解密11版本及以前的密码 //String decode = navicatPassword.decrypt("15057D7BA390", 11); // 解密12版本及以后的密码 //String decode = navicatPassword.decrypt("15057D7BA390", 12); String decode = navicatPassword.decrypt("解密密码", 12); System.out.println(decode); } private static final String AES_KEY = "libcckeylibcckey"; private static final String AES_IV = "libcciv libcciv "; private static final String BLOW_KEY = "3DC5CA39"; private static final String BLOW_IV = "d9c7c3c8870d64bd"; public static String encrypt(String plaintext, int version) throws Exception { switch (version) { case 11: return encryptEleven(plaintext); case 12: return encryptTwelve(plaintext); default: throw new IllegalArgumentException("Unsupported version"); } } public static String decrypt(String ciphertext, int version) throws Exception { switch (version) { case 11: return decryptEleven(ciphertext); case 12: return decryptTwelve(ciphertext); default: throw new IllegalArgumentException("Unsupported version"); } } private static String encryptEleven(String plaintext) throws Exception { byte[] iv = hexStringToByteArray(BLOW_IV); byte[] key = hashToBytes(BLOW_KEY); int round = plaintext.length() / 8; int leftLength = plaintext.length() % 8; StringBuilder result = new StringBuilder(); byte[] currentVector = iv.clone(); Cipher cipher = Cipher.getInstance("Blowfish/ECB/NoPadding"); SecretKeySpec secretKeySpec = new SecretKeySpec(key, "Blowfish"); cipher.init(Cipher.ENCRYPT_MODE, secretKeySpec); for (int i = 0; i < round; i++) { byte[] block = xorBytes(plaintext.substring(i * 8, (i + 1) * 8).getBytes(), currentVector); byte[] temp = cipher.doFinal(block); currentVector = xorBytes(currentVector, temp); result.append(bytesToHex(temp)); } if (leftLength > 0) { currentVector = cipher.doFinal(currentVector); byte[] block = xorBytes(plaintext.substring(round * 8).getBytes(), currentVector); result.append(bytesToHex(block)); } return result.toString().toUpperCase(); } private static String encryptTwelve(String plaintext) throws Exception { byte[] iv = AES_IV.getBytes(); byte[] key = AES_KEY.getBytes(); Cipher cipher = Cipher.getInstance("AES/CBC/NoPadding"); SecretKeySpec secretKeySpec = new SecretKeySpec(key, "AES"); IvParameterSpec ivParameterSpec = new IvParameterSpec(iv); cipher.init(Cipher.ENCRYPT_MODE, secretKeySpec, ivParameterSpec); byte[] result = cipher.doFinal(plaintext.getBytes()); return bytesToHex(result).toUpperCase(); } private static String decryptEleven(String ciphertext) throws Exception { byte[] iv = hexStringToByteArray(BLOW_IV); byte[] key = hashToBytes(BLOW_KEY); byte[] encrypted = hexStringToByteArray(ciphertext.toLowerCase()); int round = encrypted.length / 8; int leftLength = encrypted.length % 8; StringBuilder result = new StringBuilder(); byte[] currentVector = iv.clone(); Cipher cipher = Cipher.getInstance("Blowfish/ECB/NoPadding"); SecretKeySpec secretKeySpec = new SecretKeySpec(key, "Blowfish"); cipher.init(Cipher.DECRYPT_MODE, secretKeySpec); for (int i = 0; i < round; i++) { byte[] block = Arrays.copyOfRange(encrypted, i * 8, (i + 1) * 8); byte[] temp = xorBytes(cipher.doFinal(block), currentVector); currentVector = xorBytes(currentVector, block); result.append(new String(temp)); } if (leftLength > 0) { currentVector = cipher.doFinal(currentVector); byte[] block = Arrays.copyOfRange(encrypted, round * 8, round * 8 + leftLength); result.append(new String(xorBytes(block, currentVector))); } return result.toString(); } private static String decryptTwelve(String ciphertext) throws Exception { byte[] iv = AES_IV.getBytes(); byte[] key = AES_KEY.getBytes(); byte[] encrypted = hexStringToByteArray(ciphertext.toLowerCase()); Cipher cipher = Cipher.getInstance("AES/CBC/NoPadding"); SecretKeySpec secretKeySpec = new SecretKeySpec(key, "AES"); IvParameterSpec ivParameterSpec = new IvParameterSpec(iv); cipher.init(Cipher.DECRYPT_MODE, secretKeySpec, ivParameterSpec); byte[] result = cipher.doFinal(encrypted); return new String(result); } private static byte[] xorBytes(byte[] bytes1, byte[] bytes2) { byte[] result = new byte[bytes1.length]; for (int i = 0; i < bytes1.length; i++) { result[i] = (byte) (bytes1[i] ^ bytes2[i]); } return result; } private static byte[] hexStringToByteArray(String s) { int len = s.length(); byte[] data = new byte[len / 2]; for (int i = 0; i < len; i += 2) { data[i / 2] = (byte) ((Character.digit(s.charAt(i), 16)

【本文地址】

公司简介

联系我们