MySQL aes_encrypt layout scheme?

Question

Does anyone know which mysql padding scheme uses for its aes_encrypt?

I did a lot of searches, and all I found was "byte padding". But this is too common!

thanks

Answer 1

Data filling is performed according to RFC3369 / PKCS # 5. The keys are filled with zeros. Unfortunately, none of them are documented, but I got information from this error report:

http://bugs.mysql.com/bug.php?id=16713

Answer 2

Here's a good explanation with code demonstrating how add-on # works.

Answer 3

If you don’t know which add-on is being used, decrypt it using NoPadding. Look at what was added at the end of the last block, and this will tell you which fill style is being used.

Answer 4

This answer set me on the right path:

fooobar.com/questions/1211282 / ...

So this is really PKCS7, as Mark Adams noted.

Hope this helps someone.