Mysql Base64 encode/decode

TO_BASE64() :  Return the argument converted to a base-64 string

 

FROM_BASE64() : Decode base64 encoded string and return result

 

-----------------------------------------------------

1. SELECT TO_BASE64('abc') encodeStr, convert(FROM_BASE64(TO_BASE64('abc'))) decodeStr;

 

 

2. 로그인 mysql -uroot -p --skip-binary-as-hex

  SELECT TO_BASE64('abc') encodeStr, FROM_BASE64(TO_BASE64('abc')) decodeStr;