How to generates random bytes using the RANDOM_BYTES() function?

RANDOM_BYTES(len) is a MySQL built-in function that generates random bytes of a given length. For example:

SELECT HEX(RANDOM_BYTES(16)), HEX(RANDOM_BYTES(16));
  -- +----------------------------------+----------------------------------+
  -- | HEX(RANDOM_BYTES(16))            | HEX(RANDOM_BYTES(16))            |
  -- +----------------------------------+----------------------------------+
  -- | A81DAEC87FC92E7C630ED06A8AA04842 | 5ECF237CF5C416561665EBD68968B109 |
  -- +----------------------------------+----------------------------------+

Reference information of the RANDOM_BYTES() function:

RANDOM_BYTES(len): bin
  generates random bytes of a given length.

Arguments, return value and availability:
  len: Required. The number of bytes to be generated.
  bin: Return value. The generated byte string.
  Available since MySQL 4.1.

⇒ SHA() - Synonym for SHA1()

⇐ MD5() - Calculating MD5 Hash

⇑ MySQL Functions for Encryption and Compression

⇑⇑ MySQL Function References