If you run multiple MySQL instances on a Linux machine, chances
are good that at one time or another, you’ve ended up connected
to an instance other than what you had intended. It’s certainly
happened to me, and I submitted Bug#76512 to deal with the cause which affects me
most commonly – that the mysql client will silently ignore the
–port option and connect using the default Unix socket instead
when the host is “localhost” (default). We’ve recently
discussed ways we can make this behavior less surprising to
users, and though we’re now past the second RC of MySQL Server
5.7, we’re contemplating making these changes in future 5.7
releases. Please let us know your thoughts!
Here are the basic principles of what we intend to change:
Explicit –protocol option rules all
If a user provides an explicit …
[Read more]