MySQL Forums
Forum List  »  Triggers

Re: logon trigger to restrict login from workbench
Posted by: Peter Brawley
Date: January 30, 2018 01:14PM

A MySQL Trigger can be defined only for Insert, Update and Delete SQL commands.

To restrict non-admin MySQL login to a particular app,

- define a user/password combo specifically for that app

- have that app issue its own passwords for its users, authenticating them against its own password table

- do not publish mysql passwords for root or other admin users

Options: ReplyQuote

Written By
Re: logon trigger to restrict login from workbench
January 30, 2018 01:14PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.