Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

When trying to restore a backup taken from a 5.6.x server to an 8.x server, this error prevented the successful restore:

Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’

This was filed under bug 90624 and is caused by 8.x not using that statement. I switched from SQLBackupAndFTP to Navicat and the error did not occur in Navicat (though it was significantly slower). Supposedly it’s also corrected in MySQL Workbench.

Since Windows users can only migrate from a 5.x to an 8.x server using this method can this be fixed in this program? (hack fix is to open your .sql file and remove those statements but this won’t work for large files without a utility like sed)

Hi Steve_Logan,

SQLBackupAndFTP was designed to backup and restore SQL Server, MySQL, PostgreSQL, and Azure SQL databases, but not for the migration.

Sorry, but we cannot help you with this issue.

If you have any other questions, please let us know.