Connect to the localhost using TCP about sequel-ace HOT 7 OPEN

I thought we fixed this ~3 years ago? #765
Not sure why we're having trouble here - the code should explicitly force localhost to be TCP/IP if you have TCP/IP selected
Can we get some screenshots of your connection configuration and the error message?

from sequel-ace.

Maybe I'm reading this error message incorrectly?

from sequel-ace.

There are different error messages for 127.0.0.1 and localhost

from sequel-ace.

It may be possible it's falling back on the socket if it cannot connect via TCP/IP?
Can you try with the correct password and see?

from sequel-ace.

Same problem here. I tried as 'root' and defined user - in terminal connection works in Sequel Ace it is not.

Standard connection, not the socket.

from sequel-ace.

Same here

When using the following command in terminal "mysql -uroot" it connects as expected.

But when I attempt to use Sequel Ace it doesn't work. It worked earlier today, but after I restarted mysql service (brew service restart mysql) it stopped working in Sequel Ace but not in terminal.

EDIT
For me this was related to "skip-name-resolve=ON" being enabled in my.cnf, localhost could not be resolved to 127.0.0.1, and when I attempted to use 127.0.0.1 I got an error message saying that the host 127.0.0.1 is not allowed.

Removed "skip-name-resolve=ON" and restarted mysql, and now localhost works as expected.

from sequel-ace.

from sequel-ace.