LMSouq
general-dev Open

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

KE
kenpeter
1 month ago
3 views
Problem Description
So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access denied; you need (at least one of) the SUPER privilege(s) for this operation The actual sql content is: /*!50003 CREATE*/ /*!50017 DEFINER=`another_user`@`1.2.3.4`*/ /*!50003 TRIGGER `change_log_BINS` BEFORE INSERT ON `change_log` FOR EACH ROW IF (NEW.created_at IS NULL OR NEW.created_at = '00-00-00 00:00:00' OR NEW.created_at = '') THEN SET NEW.created_at = NOW(); END IF */;; `another_user` is not existed in rds, so I do: GRANT ALL PRIVILEGES ON db.* TO another_user@'localhost'; Still no luck.

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base