title: MySQL 5.5 - Can't see Triggers
body: <p>I'm not sure what I'm doing wrong, but I cannot see any of the triggers on my database. I have a pair of replicated servers (Windows 2008 R2) running 5.5.23 and awhile back I had created some triggers to update a date modified field everytime a record gets updated. If definitely works as if I go into the database and update a field, that record shows the latest time.</p>
  
  <p>I've tried doing "Show Triggers" and no records are returned. I've done the same thing in command prompt and no records are returned. There are no records returned from the TRIGGERS table in the information_schema as well.</p>
  
  <p>The triggers were likely created in MySQL 5.1. Could that be the problem?</p>
  
  <p>Thanks!</p>
  
  <p>FIX:
  I figured it out. It turned out to be a crazy permissions problem in Windows. The solution? Go into the Users table in MySQL and change any values to "Y" that are set to "N" (I believe: Event_priv, Trigger_priv, Create_tablespace_priv) and restart MySQL. They appear now.</p>