My Oracle Support Banner

Error Using mysqldump : "Couldn't execute 'show events': Access denied .. to database 'performance_schema' (1044)" (Doc ID 1984203.1)

Last updated on APRIL 15, 2020

Applies to:

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

Symptoms

The command mysqldump fails with following error:

shell> mysqldump -u<ROOT_USER>  --single-transaction --hex-blob --master-data=2 --routines --triggers --events --all-databases > output.sql
mysqldump: Couldn't execute 'show events': Access denied for user '<ROOT_USER>'@'<HOST_NAME>' to database 'performance_schema' (1044)

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
Cause
Solution
References


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