Answers.Body: <p>Here is the <a href="https://help.poralix.com/articles/mysql-access-denied-you-need-the-super-privilege-for-this-operation" rel="nofollow noreferrer">Solution.</a> Clearing a couple of lines from the SQL file made it work.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-09-18T00:15:55.513Z
Answers.LastActivityDate: 2019-09-18T00:15:55.513Z
Answers.UserDisplayName: Dustin C
Body: <p>I downloaded a database backup from the craft back-end. I've tried to restore it via PHPMyAdmin and MySQL workbench, and I get the following errors:</p>
  
  <p><code>ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation</code></p>
  
  <p>At line 18 in the SQL file:</p>
  
  <p><code>SET @@SESSION.SQL_LOG_BIN= 0;</code></p>
  
  <p>Is there any way I can get around this so I can restore this database? I'm desperate right now.</p>
  
Tags: <database>
Title: Restoring a database results in error
ThreadText: # Restoring a database results in error
  
  (Asked by: username_0 on 2019-09-17)
  
  I downloaded a database backup from the craft back-end. I've tried to restore it via PHPMyAdmin and MySQL workbench, and I get the following errors:
  
  `ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation`
  
  At line 18 in the SQL file:
  
  `SET @@SESSION.SQL_LOG_BIN= 0;`
  
  Is there any way I can get around this so I can restore this database? I'm desperate right now.
  
  **Tags:** database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-09-18. Score: 1 | Accepted answer
  
  Here is the [Solution.](https://help.poralix.com/articles/mysql-access-denied-you-need-the-super-privilege-for-this-operation) Clearing a couple of lines from the SQL file made it work.
  
  
  ---
  
  