Won't Do
Details
Assignee
UnassignedUnassignedReporter
Nickolay IhalainenNickolay Ihalainen(Deactivated)Labels
Upstream Bug URL
Affects versions
Priority
Low
Details
Details
Assignee
Unassigned
UnassignedReporter
Nickolay Ihalainen
Nickolay Ihalainen(Deactivated)Labels
Upstream Bug URL
Affects versions
Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created November 9, 2018 at 11:01 AM
Updated March 4, 2025 at 9:02 PM
Resolved March 4, 2025 at 9:02 PM
I have two views:
create DEFINER=test@'%' SQL SECURITY INVOKER VIEW test.v0 AS SELECT 1;
create DEFINER=test@'%' SQL SECURITY INVOKER VIEW test.v1 AS SELECT 1 FROM test.v0;
mysql root user is removed.
Trying to import dump to a just created server and getting surprising error:
ERROR 1449 (HY000) at line 938: The user specified as a definer ('root'@'localhost') does not exist
5.5 - not affected, because it uses temporary myisam table
5.6, 5.7 and 8.0 (requires longer sleeps) producing:
ERROR 1449 (HY000) at line 974: The user specified as a definer ('root'@'localhost') does not exist
Different versions have a slightly different line containing statement:
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`test`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `v0` AS select 1 AS `1` from `v1` */;
At this moment, temporary view defined as:
/*!50001 CREATE VIEW `v1` AS SELECT
1 AS `1`*/;