Mit

Mysql Aes_Encrypt 쿼리 select HEX(AES_ENCRYPT('텍스트','비밀번호')); C# Encrypt String(HEX) private static string Encrypt(string _encryptString, string _passkey) { StringBuilder sbResult = new StringBuilder(); byte[] EncryptArray = UTF8Encoding.UTF8.GetBytes(_encryptString); RijndaelManaged Rdael = new RijndaelManaged(); Rdael.KeySize = 128; Rdael.BlockSize = 128; Rdael.Mode = CipherMode.CBC; Rdael.Paddi..

Mysql Aes_Decrypt 쿼리 select cast(AES_DECRYPT(unhex('암호텍스트'),'비밀번호') as char(100)) from log_member; ---------------------------------------------------------------------------------------------------- C# Decrypt String public static string Decrypt(string _decryptString, string _passkey) { RijndaelManaged Rdael = new RijndaelManaged(); Rdael.Mode = CipherMode.CBC; Rdael.Padding = PaddingMode.PKCS7..

Nginx .Net Core5 Mysql Connection String static private MySqlConnection EDC_conn; static private string EDC_GetConnectionString() { return "Server=서버IP ; Port=3306; Database=log_in; Uid = 아이디; Pwd=비밀번호; SslMode=Required;"; } static private string member_search(Member_CHK Items) { try { string EDC_connectionString = EDC_GetConnectionString(); using (EDC_conn = new MySqlConnection(EDC_connectionSt..