Consider root user with 2 application user having privileges to specific databases alone. If keyring keys were created for 2 application users(session users) by default keyring_key_generate. How do mysql internally fetch keys? is it based on logged-in users or mysql have the association somewhere?
So root user can decrypt all users data ?
Command used to create key
SELECT keyring_key_generate('MyKey', 'DSA', 256);
Basically how to assign a key for a user in mysql keyring_file plugin