All geek questions in one place

Access denied, you need super privilege for this operation in sql query browser

I am very new to sql. Now I'm trying to host an application on amazon that uses a database. so I create an ec2 instance and use the sql query browser connecting to the rds instance in amazon. I import the .sql dump file and execute it. I get an error in this statement ... CREATE DEFINER = 'root' @localhost 'PROCEDURE'delete_user_message' (in id varchar (20)) as Access denied, you need (at least one of) super privileges for this operation. error (1227). How can I fix this and create a database

+4
source share
1 answer

The problem is that in RDS you do not get the SUPER privileges that are necessary to create a procedure belonging to another user. To make this work, all you have to do is delete the DEFINER part of your statement. Then it will automatically use the current user.

+8
source

Source: https://habr.com/ru/post/1500025/

More articles:


All Articles