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

CC BY-SA 4.0
2019-09-18T00:15:55.513Z
2019-09-18T00:15:55.513Z
Dustin C
<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>

<database>
Restoring a database results in error
# 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.


---

