關於 MySQL ENCRYPT()

mankowk

我在 MySQL 試下 ENCRYPT()

1. SELECT ENCRYPT('123456789',CONCAT('$7$',SUBSTRING(SHA(RAND()),2)));
     出 NULL

2. SELECT ENCRYPT('123456789',CONCAT('$6$',SUBSTRING(SHA(RAND()),2)));
    出 一堆字串

請問各位師兄, 點解會出 NULL,
我試到 $1$ and $6$ 都有字串出,
$2$, $3$, $4$, $7$ 好多都出 NULL.

1. SELECT ENCRYPT('123456789',CONCAT('$7,SUBSTRING(SHA(RAND()),2)));
   
2. 
   
3. SELECT ENCRYPT('123456789',CONCAT('$6,SUBSTRING(SHA(RAND()),2)));

複製代碼

rabbit82047

因為 7 唔係正確 ID, 基本上只可用 1, 5, 6

       If salt is a character string starting with the characters "$id$"
       followed by a string optionally terminated by "$", then the result
       has the form:

              $id$salt$encrypted

       id identifies the encryption method used instead of DES and this then
       determines how the rest of the password string is interpreted.  The
       following values of id are supported:

              ID  | Method
              1   | MD5
             2a  | Blowfish (not in mainline glibc; added in some Linux distributions)
              5   | SHA-256 (since glibc 2.7)
              6   | SHA-512 (since glibc 2.7)

因為 mysql encrypt 係用 system crypt
Linux crypt man page:
http://man7.org/linux/man-pages/man3/crypt.3.html

mankowk

回覆 2# rabbit82047


    原來係咁、明白晒、3q