Mysql – unknown variable after upgrading from theSQL 5.7 to 8

MySQL

After upgrading from mySQL 5.7 to 8.0 on freebsd, I keep getting the follow error, which prevents mysql to start:

[ERROR] [MY-000067] [Server] unknown variable 'innodb_large_prefix=true'.

The thing is that setting is not on my my.cnf file. I understand it is deprecated on mySQL 8, but it is not on my configuration.

Is there a way to fix it?

Best,
Francis

Best Answer

Found it. Apparently there was a naughty my.cnf file under /usr/local, where the variable was. Problem fixed by commenting it.