I’ve moved from a 10.3 installation to a 10.5 installation, and ported my various my.cnf settings over.
One of those is
If I leave it in I’m suddenly unable to connect to the database with Navicat. Normally it uses an SSH tunnel and then connets to
localhost on port
1045 Access denied for user 'root'@'127.0.0.1' (using password: YES)
My web app is unaffected, and can still connect to the database happily.
If I take it out, I can connect quite happily. What should I change? I tried changing localhost to 127.0.0.1 but that made no difference.