Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Grant event privilege to a user GRANT EVENT ON mydb.* TO "app_user"@"localhost"; -- Show grants SHOW GRANTS FOR "app_user"@"localhost"; -- Create event with specific definer CREATE DEFINER = "admin"@"localhost" EVENT secure_cleanup ON SCHEDULE EVERY 1 HOUR DO DELETE FROM sessions WHERE expired = 1; -- Event runs with admin privileges, not the user who created it via app_user
Result
Open