...

View Full Version : show triggers does not work



BubikolRamios
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.
Executed:


flush privileges


No effect. ?

devnty06
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']
[REQUIRE encryption]
WITH with_options

BubikolRamios
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.

BubikolRamios
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum