title: SUPER privilege(s) for this operation
body: <p>I create my database and user <code>navid</code> in my shared server with <code>cpanel</code> (<code>databases -&gt; mySQL@ Databases -&gt; add new user</code>),and then selected ALL PRIVILEGES for user <code>navid</code>.
  I was importing <code>mydatabase.sql</code> when I was confronted with this error.</p>
  
  <hr>
  
  <p>how do i fix the error?  store procedure worked fine in <code>localhost</code>.</p>
  
  <hr>
  
  <p>what is SUPER privilege?</p>
  
  <pre><code>Error
  SQL query:
  DELIMITER $$--
  -- Procedures
  --
  CREATE DEFINER = `navid`@`%` PROCEDURE `d_answer` ( OUT `sp_out` INT( 11 ) , IN `sp_id` INT( 11 ) ) NO SQL BEGIN DELETE FROM `tblname` WHERE `a_id` = sp_id;
  SET sp_out = ROW_COUNT( ) ;
  END$$
  
  MySQL said: Documentation
  #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation 
  </code></pre>