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 NOVEMBER 28, 2022

Applies to:

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

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

Loading mysqldump file into the database.

	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

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