Add TRIGGER privilege management for database users
Some of our customers are asking for a way to define triggers on their MySQL/MariaDB databases. Plesk does not grant the TRIGGER privilege on database users it creates.
Modifying the GRANTs for those users created by Plesk is not a viable workaround, because the permissions get reset if the user is later modified at all via Plesk.
The only known workaround is to create and manage a separate database user outside of Plesk, which is obviously contrary to the purpose of having Plesk on a server in the first place.
Please consider adding TRIGGER privilege management to Plesk, or else a supported way to retain customised database user permissions.
Thank you for your input. We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.