Error
Error Code:
3880
MySQL Error 3880: AuthId System Privilege Conflict
Description
This error occurs when attempting to configure the `mandatory_roles` system variable with a user or role (AuthId) that already holds a system-level privilege, such as `SYSTEM_USER`. MySQL prevents this assignment to avoid privilege management conflicts and ensure system stability.
Error Message
Cannot set mandatory_roles: AuthId `%s`@`%s` has '%s' privilege.
Known Causes
3 known causesUser with SYSTEM_USER Privilege
An attempt was made to assign a user account that holds the `SYSTEM_USER` privilege to the `mandatory_roles` system variable.
Role with SYSTEM_USER Privilege
You tried to include a role that has been granted the `SYSTEM_USER` privilege in the `mandatory_roles` system variable.
Incorrect `mandatory_roles` Configuration
The configuration for `mandatory_roles` violates MySQL's rules by including an authentication ID with system-level privileges.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service