Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Access denied; you need (at least one of) the SUPER privilege(s) for this operation #23

Closed
michalbiarda opened this issue Jun 13, 2022 · 0 comments
Closed

Access denied; you need (at least one of) the SUPER privilege(s) for this operation #23

michalbiarda opened this issue Jun 13, 2022 · 0 comments
Assignees
@michalbiarda
Labels
bug
Milestone
4.0.0

Comments

@michalbiarda
Copy link
Contributor

ERROR 1227 (42000) at line 12048: Access denied; you need (at least one of) the SUPER privilege(s) for this operation is thrown when importing database from S3.

Most probably this is caused by DEFINER in DB dump not matching local user.

See: https://stackoverflow.com/questions/44015692/access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operat

We could try to configure mysqldump to omit DEFINER (if this is possible) or we could remove DEFINER after mysqldump.
@michalbiarda michalbiarda added this to the 4.0.0 milestone Jun 22, 2022
@michalbiarda michalbiarda moved this to Todo in Driver Jun 22, 2022
@michalbiarda michalbiarda self-assigned this Jun 23, 2022
@michalbiarda michalbiarda moved this from Todo to In Progress in Driver Jun 27, 2022
michalbiarda added a commit that referenced this issue Jun 27, 2022
@michalbiarda
#23 - fix for Access Denied issue when importing database from S3
103d2c1
michalbiarda added a commit that referenced this issue Jun 30, 2022
@michalbiarda
#23 - mysqldump command upgraded with smarter DEFINER change
fba0412
michalbiarda added a commit that referenced this issue Jun 30, 2022
@michalbiarda
Merge pull request #31 from swiftotter/23-access-denied-issue
15a04b7 
#23 - fix for Access Denied issue when importing database from S3
@michalbiarda michalbiarda moved this from In Progress to QA in Driver Jun 30, 2022
@michalbiarda michalbiarda moved this from QA to Done in Driver Jul 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@michalbiarda michalbiarda

Labels
bug
Projects
Driver
Status: Done
Milestone
4.0.0
Development

No branches or pull requests
1 participant
@michalbiarda