Reputation
1,726
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 9 4
Newest
 Yearling
Impact
~248k people reached

  • 0 posts edited
  • 0 helpful flags
  • 22 votes cast
Apr
15
comment MySQL: Bind to more than one IP address?
@AJP Mysql treats ‘localhost’ and ‘127.0.0.1’ differently in the privilege system. Confirmed here : A Unix socket file is used if you do not specify a host name or if you specify the special host name localhost.
Apr
14
comment MySQL: Bind to more than one IP address?
@AJP I suspect that in your second case, the client connects to localhost via the socket as danorton said in his comment. I did not check this, though.
Apr
14
comment MySQL: Bind to more than one IP address?
@AJP the question was about the server listening to multiple IP addresses. You can connect to any address you like with the client.