On Jan 14, 2012, at 11:15 AM, Chuck Swiger wrote:
> Anyway, doesn't the mysql port want to keep the socket under
> /var/run/mysql/mysqld.sock or some such, to avoid issues with /tmp?
Turns out some applications won't work if you move the socket if they are
configured to access localhost. Seem
On Jan 14, 2012, at 5:18 PM, Paul Beard wrote:
> Turns out some applications won't work if you move the socket if they are
> configured to access localhost. Seems like a misunderstanding of networking
> if you can specify a port number in a configuration file but the application
> looks to the f
On Jan 15, 2012, at 8:17 AM, Chuck Swiger wrote:
> Something looking for a network location specified as a host and port (ie,
> localhost:3306) is using a TCP socket. Something looking for
> /tmp/mysqld.sock is using a UNIX domain socket.
>
> Changing the path to the UNIX domain socket will h
On Jan 15, 2012, at 8:43 AM, Paul Beard wrote:
> Useful clarification but a UNIX domain socket sounds less like networking and
> more like interprocess communication, i.e., something explicitly tied to a
> single host.
Yes, that's right.
> There is a "skip networking" option for MySQL that refe
On Jan 15, 2012, at 9:20 AM, Chuck Swiger wrote:
> You're confusing two things which are different.
At the risk of boring everyone on this list, I think I understand it as far as
I need to: I am not the developer of the app(s) that seem to generate this
issue.
> If you specify a path via "-
On 15/01/2012 17:20, Chuck Swiger wrote:
> If you specify a hostname and port via "--host=localhost
> --port=3306", then you are describing a TCP socket. There is no
> pathname involved. You could connect regardless of where mysqld is
> putting the socket.
Some MySQL clients will gratuitously ch
On 15/01/2012 17:50, Paul Beard wrote:
> The app configurations are not this granular: hostname and port are
> configured but there is nothing that makes clear that IF you specify
> localhost, you WILL BE using a domain socket which MUST BE
> /tmp/mysql.sock and IF you move it or your distribution