Warning |
---|
You have tried to access an archived page. Please go to the new https://root360.atlassian.net/wiki/spaces/KB to find more documents. |
...
Table of Contents |
---|
Error
When importing a MySQL dump, the following error occurs:
Code Block | ||||
---|---|---|---|---|
| ||||
ERROR 1227 (42000) at line 7692: Access denied; you need (at least one of) the SUPER privilege(s) for this operation. |
...
1. Enable the use of functions, triggers, views
Root360 can use a support ticket to enable the use of SQL functions, views, and stored procedures. For this purpose, the following value must be set in the RDS parameter group:
Code Block | ||||
---|---|---|---|---|
| ||||
log_bin_trust_function_creators = 1 |
2. Set DEFINER correctly
If DEFINER statements with fixed SQL users are specified in the SQL dump, they must be replaced with the user that is doing the import.
Before:
DEFINER = user_a @all
or
DEFINER=user_a@localhost
after:
DEFINER = correctuser @all
To replace all DEFINER statements, the following sed command can be used on the NATGW:
Code Block | ||||
---|---|---|---|---|
| ||||
sed -i "s/DEFINER=\`[^\`]*\`@\`[^\`]*\`/DEFINER=\`USERNAME\`@\`%\`/g" CustomerSQLDump.sql |
...