View Full Version : show triggers does not work
09-19-2011, 03:04 PM
It is said I need super privilege, so I opened mysql.user table
and set all to Y including super except grant and shutdown.
No effect. ?
09-20-2011, 11:24 AM
Have you followed these steps?
GRANT privileges (column_list)
ON [object_type] privilege_level
TO account [IDENTIFIED BY 'password']
09-20-2011, 07:26 PM
Did that first, for SUPER, it executed, and there were no effects. Hence I went to find the table and manualy set all to yes.
09-22-2011, 08:53 AM
ahh, there are db and user tables, both having trigger privilege. Turned all to Y for all users.
Flush privileges, no effect.
Restart server, and it works.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.