Skip to content

mysqldump: Error: 'Access denied #218

Open
@ploitivel

Description

@ploitivel

I am getting the following error : mysql:8.0.

docker logs backup

  • mysqldump -h db -P 3306 -uroot -psecret@_sql -A
    mysqldump: Error: 'Access denied; you need (at least one of) PROCESS privileges for this operation' when trying to dump tablespaces

About the access mysqldump denied PROCESS privilege error
mysqldump accesses tablespace information in the FILES table. Prior to MySQL 5.7.31 and 8.0.21, your user could run mysqldump without the PROCESS privilege. However, users running mysqldump after the update need PROCESS privileges to access the INFORMATION_SCHEMA.FILES table. Running mysqldump without PROCESS privilege ends up giving you an Access denied error.

What could I do in these cases?
From what I see the container is only for using mysql 5.7

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions