ERROR 1231 (42000) at line 793: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

Asked May 26 '22 at 07:39

Active Jun 02 '22 at 07:28

Viewed 26 times

-1

when I am trying to import database backup from mysql workbench version 6.3CE to mysql workbench version 8.0CE I am getting this error.

ERROR 1231 (42000) at line 793: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

really your help will become more helpful and appreciable.

edited Jun 02 '22 at 07:28

asked May 26 '22 at 07:39

Sagar

You might want to check other questions like https://stackoverflow.com/questions/50336378/variable-sql-mode-cant-be-set-to-the-value-of-no-auto-create-user – Progman May 28 '22 at 09:36

0 Answers0