暗号化の復号について

暗号と復号について

alter table administrators encrypted=yes; noで切り替え可能

MariaDB [uims_test]> alter table administrators encrypted=yes;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '=yes' at line 1

MariaDB [uims_test]> alter table administrators encrypted=yes;

Query OK, 0 rows affected (0.030 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [uims_test]> alter table administrators encrypted=no;

Query OK, 0 rows affected (0.019 sec)

Records: 0  Duplicates: 0  Warnings: 0

内部的なデータの確認

暗号前:

root@5a81afabdd12:/# strings /var/lib/mysql/uims_test/administrators.ibd 

BQTU*V

TU*V

infimum

supremum

infimum

supremum

infimum

supremum

root@5a81afabdd12:/# 

暗号後:

root@5a81afabdd12:/# strings /var/lib/mysql/uims_test/administrators.ibd 

quFI

[oNt

9&H~

r@J*

>"@=

...

復号後:

root@5a81afabdd12:/# strings /var/lib/mysql/uims_test/administrators.ibd 

infimum

supremum

infimum

supremum

多分戻ってる