Tagged articles

DEFINER

2 articles · Page 1 of 1

Dec 18, 2025 · Databases

Detect and Clean Root‑Defined MySQL Objects After Renaming the Root User

This guide explains how to identify stored procedures, functions, views, and triggers that still use DEFINER='root'@'%' after renaming the MySQL root account, and provides a Python script to generate and execute the necessary DROP statements across many databases.

DEFINERPython scriptRoot User

0 likes · 8 min read

Detect and Clean Root‑Defined MySQL Objects After Renaming the Root User

Aikesheng Open Source Community

Sep 24, 2020 · Databases

Modifying mysqldump to Remove DEFINER and Add Progress Display for MySQL 5.7

This article explains why restoring MySQL backups can fail due to missing SUPER privileges, describes the DEFINER and SQL SECURITY concepts, and details how the mysqldump source code was altered for MySQL 5.7 to strip DEFINER clauses, show backup progress, and improve performance testing.

DEFINERmysqldumpperformance

0 likes · 8 min read

Modifying mysqldump to Remove DEFINER and Add Progress Display for MySQL 5.7