Error
Error Code:
1285
MariaDB Error 1285: Grants Fail with Name Resolution Disabled
Description
This error indicates that a `GRANT` statement cannot be processed because the MariaDB server is currently running with the `--skip-name-resolve` option enabled. This setting prevents the server from resolving hostnames to IP addresses, which is essential for `GRANT` statements that define user permissions based on hostnames.
Error Message
MariaDB is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work
Known Causes
3 known causesManual Startup with Skip-Name-Resolve
The MariaDB server was explicitly started from the command line or a script using the `--skip-name-resolve` option.
Configuration File Setting
The `skip-name-resolve` directive is present and enabled in the MariaDB configuration file (e.g., `my.cnf` or `my.ini`), causing the server to start in this mode.
Granting with Hostnames
An attempt was made to execute a `GRANT` statement that specifies a user's host by name (e.g., `user@'hostname'`), which requires hostname resolution.
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