2026-10-21T11:56:45.930695Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
MySQL 5.6 引入了 NO_AUTO_CREATE_USER 这个 SQL mode 来禁止 GRANT 语句自动创建不存在的用户。
MySQL 5.7.6+ 默认启用 NO_AUTO_CREATE_USER，给不存在的用户授予权限会直接报错。- ERROR 1133 (42000): Can't find any matching row in the user table
- Warning (Code 1287): Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement.
|
|