1select des_encrypt("test", 'akeystr'); 2des_encrypt("test", 'akeystr') 3NULL 4Warnings: 5Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 6select des_encrypt("test", 1); 7des_encrypt("test", 1) 8NULL 9Warnings: 10Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 11select des_encrypt("test", 9); 12des_encrypt("test", 9) 13NULL 14Warnings: 15Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 16select des_encrypt("test", 100); 17des_encrypt("test", 100) 18NULL 19Warnings: 20Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 21select des_encrypt("test", NULL); 22des_encrypt("test", NULL) 23NULL 24Warnings: 25Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 26select des_encrypt(NULL, NULL); 27des_encrypt(NULL, NULL) 28NULL 29Warnings: 30Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 31select des_decrypt("test", 'anotherkeystr'); 32des_decrypt("test", 'anotherkeystr') 33NULL 34Warnings: 35Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 36select des_decrypt(1, 1); 37des_decrypt(1, 1) 38NULL 39Warnings: 40Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 41select des_decrypt(des_encrypt("test", 'thekey')); 42des_decrypt(des_encrypt("test", 'thekey')) 43NULL 44Warnings: 45Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 46select hex(des_encrypt("hello")),des_decrypt(des_encrypt("hello")); 47hex(des_encrypt("hello")) des_decrypt(des_encrypt("hello")) 48NULL NULL 49Warnings: 50Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 51Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 52select des_decrypt(des_encrypt("hello",4)); 53des_decrypt(des_encrypt("hello",4)) 54NULL 55Warnings: 56Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 57select des_decrypt(des_encrypt("hello",'test'),'test'); 58des_decrypt(des_encrypt("hello",'test'),'test') 59NULL 60Warnings: 61Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 62select hex(des_encrypt("hello")),hex(des_encrypt("hello",5)),hex(des_encrypt("hello",'default_password')); 63hex(des_encrypt("hello")) hex(des_encrypt("hello",5)) hex(des_encrypt("hello",'default_password')) 64NULL NULL NULL 65Warnings: 66Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 67Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 68Warning 1289 The 'des_encrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 69select des_decrypt(des_encrypt("hello"),'default_password'); 70des_decrypt(des_encrypt("hello"),'default_password') 71NULL 72Warnings: 73Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 74select des_decrypt(des_encrypt("hello",4),'password4'); 75des_decrypt(des_encrypt("hello",4),'password4') 76NULL 77Warnings: 78Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 79SET @a=des_decrypt(des_encrypt("hello")); 80Warnings: 81Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 82flush des_key_file; 83select @a = des_decrypt(des_encrypt("hello")); 84@a = des_decrypt(des_encrypt("hello")) 85NULL 86select hex("hello"); 87hex("hello") 8868656C6C6F 89select hex(des_decrypt(des_encrypt("hello",4),'password2')); 90hex(des_decrypt(des_encrypt("hello",4),'password2')) 91NULL 92Warnings: 93Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 94select hex(des_decrypt(des_encrypt("hello","hidden"))); 95hex(des_decrypt(des_encrypt("hello","hidden"))) 96NULL 97Warnings: 98Warning 1289 The 'des_decrypt' feature is disabled; you need MySQL built with '--with-ssl' to have it working 99