CODEWITHSUNDEEP
mysql
en Peris
en Peris

Reputation: 1717

Error importing DB in MySQL 8.0.15 from a File

I want to import some data in MySQL 8.0.15, but I got this error

Preparing...
Importing db_2019-05-25.sql...
Finished executing script
ERROR 1231 (42000) at line 3949: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
Operation failed with exitcode 1

Upvotes: 0

Views: 180

Answers (1)

sticky bit
sticky bit

Reputation: 37472

NO_AUTO_CREATE_USER was already deprecated in 5.7, already was the default there and has been removed in 8.0.

Simply remove the setting of it from the script.

Upvotes: 3

Related Questions