Yet another system (CentOS 6.4 upgraded today) where official binaries from yum repository just works:
[root@centos openxs]# mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.12-56 Percona Server (GPL), Release rc60.4, Revision 393
Copyright (c) 2009-2013 Percona Ireland Ltd.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT AES_ENCRYPT('','6b2d440b57b3bae74e3cf71e415b3965') FROM DUAL;
+----------------------------------------------------+
| AES_ENCRYPT('','6b2d440b57b3bae74e3cf71e415b3965') |
+----------------------------------------------------+
| ▌ZЦq÷▄ ╪JyйЗ |
+----------------------------------------------------+
1 row in set (0.00 sec)
Yet another system (CentOS 6.4 upgraded today) where official binaries from yum repository just works:
[root@centos openxs]# mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.12-56 Percona Server (GPL), Release rc60.4, Revision 393
Copyright (c) 2009-2013 Percona Ireland Ltd.
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT AES_ENCRYPT( '','6b2d440b57b 3bae74e3cf71e41 5b3965' ) FROM DUAL; ------- ------- ------- ------- ------- ------- ----+ '','6b2d440b57b 3bae74e3cf71e41 5b3965' ) | ------- ------- ------- ------- ------- ------- ----+ ------- ------- ------- ------- ------- ------- ----+
+------
| AES_ENCRYPT(
+------
| ▌ZЦq÷▄ ╪JyйЗ |
+------
1 row in set (0.00 sec)
mysql> exit
linux- vdso.so. 1 => (0x00007fff45cb 0000)
libpthread. so.0 => /lib64/ libpthread. so.0 (0x00007fa8fa20 e000) d000) 4000)
libcrypt. so.1 => /lib64/ libcrypt. so.1 (0x00007fa8f9bc d000)
libssl. so.10 => /usr/lib64/ libssl. so.10 (0x00007fa8f997 0000)
libcrypto. so.10 => /usr/lib64/ libcrypto. so.10 (0x00007fa8f95d 5000) 1000)
libstdc+ +.so.6 => /usr/lib64/ libstdc+ +.so.6 (0x00007fa8f90c b000) 6000)
libgcc_ s.so.1 => /lib64/ libgcc_ s.so.1 (0x00007fa8f8c3 0000) d000)
/lib64/ ld-linux- x86-64. so.2 (0x00007fa8fa43 2000)
libfreebl3. so => /lib64/ libfreebl3. so (0x00007fa8f863 a000)
libgssapi_ krb5.so. 2 => /lib64/ libgssapi_ krb5.so. 2 (0x00007fa8f83f 6000)
libkrb5. so.3 => /lib64/libkrb5.so.3 (0x00007fa8f811 0000)
libcom_ err.so. 2 => /lib64/ libcom_ err.so. 2 (0x00007fa8f7f0 b000)
libk5crypto. so.3 => /lib64/ libk5crypto. so.3 (0x00007fa8f7cd f000) 9000)
libkrb5support .so.0 => /lib64/ libkrb5support. so.0 (0x00007fa8f78b d000)
libkeyutils. so.1 => /lib64/ libkeyutils. so.1 (0x00007fa8f76b a000)
libresolv. so.2 => /lib64/ libresolv. so.2 (0x00007fa8f74a 0000)
libselinux. so.1 => /lib64/ libselinux. so.1 (0x00007fa8f728 0000) 358.6.2. el6.x86_ 64 #1 SMP Thu May 16 20:59:36 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux devel-1. 0.0-27. el6_4.2. x86_64 1.0.0-27. el6_4.2. x86_64
Bye
[root@centos openxs]# ldd `which mysqld`
libaio.so.1 => /lib64/libaio.so.1 (0x00007fa8fa00
librt.so.1 => /lib64/librt.so.1 (0x00007fa8f9e0
libdl.so.2 => /lib64/libdl.so.2 (0x00007fa8f93d
libm.so.6 => /lib64/libm.so.6 (0x00007fa8f8e4
libc.so.6 => /lib64/libc.so.6 (0x00007fa8f889
libz.so.1 => /lib64/libz.so.1 (0x00007fa8f7ac
[root@centos openxs]# uname -a
Linux centos 2.6.32-
[root@centos openxs]# rpm -q -a | grep openssl
openssl-
openssl-