My Oracle Support Banner

Restore Mysqldump File Failed With Error Message: "ERROR 1227 (42000) at line 1834: Access denied; you need (at least one of) the SUPER privilege(s) for this operation " (Doc ID 2459873.1)

Last updated on OCTOBER 14, 2018

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

Error message: "ERROR 1227 (42000) at line xxxx: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

Changes

Loading mysqldump file into the database.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.