title: MySQL Error: #1142 - TRIGGER command denied
body: <p>I need that my MySQL database makes a sum of some values in a specific coloumn. To do that I used trigger statement but MySQL gave me an error:</p>
  
  <blockquote>
    <p>MySQL Error: #1142 - TRIGGER comand denied to user 'XXXXXX' for table wp_wpdatatable_8</p>
  </blockquote>
  
  <p>the Trigger is below:</p>
  
  <pre><code>CREATE TRIGGER SumPliche AFTER INSERT ON wp_wpdatatable_8 FOR EACH ROW UPDATE wp_wpdatatable_8 SET sommapliche = tricipite + addome + soprailiaca + sottoscapolare + ascellare + pettorale + coscia
  </code></pre>
  
  <p>How can I do that?
  thanks</p>