Error
Error Code:
1700
MariaDB Error 1700: Grant illegal, user exists
Description
This error occurs when attempting to use the `GRANT ... IDENTIFIED WITH plugin` statement for a user account that already exists in the MariaDB server. MariaDB prohibits modifying an existing user's authentication method using `GRANT ... IDENTIFIED WITH`.
Error Message
GRANT with IDENTIFIED WITH is illegal because the user %-.*s already exists
Known Causes
3 known causesModifying existing user plugin
You tried to change an existing user's authentication plugin (e.g., `mysql_native_password`, `ed25519`) by using the `GRANT ... IDENTIFIED WITH` syntax, which is not allowed for existing users.
User already defined
The specified user account already exists in the `mysql.user` table, and MariaDB prevents `IDENTIFIED WITH` on an existing user via the `GRANT` statement.
Incorrect command usage
The `GRANT ... IDENTIFIED WITH` statement is intended for creating *new* users with specific authentication plugins, not for modifying existing ones.
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