EC
3196
MariaDBERRORCommonAccess ControlHIGH confidence

Command requires SUPER privilege

Production Risk

Low — access error; no data changed.

Why it happens
  1. 1Issuing a command (e.g., RESET MASTER, KILL, SET GLOBAL) without the SUPER privilege.
  2. 2Privilege escalation required for the requested administrative command.
How to reproduce
trigger — this will error
trigger — this will error
RESET MASTER;

expected output

ERROR 3196 (HY000): Access denied; you need the SUPER privilege for this operation.

Fix 1

Grant SUPER privilege

Grant SUPER privilege
GRANT SUPER ON *.* TO 'user'@'host';

Why this works

SUPER grants access to a wide range of administrative commands.

Fix 2

Grant the specific privilege needed

Grant the specific privilege needed
GRANT BINLOG_ADMIN ON *.* TO 'user'@'host';

Why this works

MySQL 8.0+ introduced fine-grained privileges as alternatives to SUPER.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 3196 ER_CMD_NEED_SUPER

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors