Question
Why can't NO_AUTO_CREATE_USER be enabled as a SQL mode for MySQL 8?
Answer
NO_AUTO_CREATE_USER has been deprecated and removed from MySQL 8 and is no longer available. It was considered an unsafe setting.
Please refer to the "Deprecation and Removal Notes" section of Changes in MySQL 8.0.11