View Full Version : show triggers does not work

09-19-2011, 04: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.

flush privileges

No effect. ?

09-20-2011, 12:24 PM
Have you followed these steps?

GRANT privileges (column_list)
ON [object_type] privilege_level
TO account [IDENTIFIED BY 'password']
[REQUIRE encryption]
WITH with_options

09-20-2011, 08: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, 09: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.