Changes
→MySQL Socket Sharing
== Sharing mysql socket ==
Wouldn't it be easier to just link the directory containing the socket using 'mount --bind'? Don't think that inode will change. [[Special:Contributions/62.195.200.207|62.195.200.207]] 16:39, 15 July 2011 (UTC)
== Linking to howto pages ==
I probably did something stupid, but how can I link from the HOWTO's to this page?
== MySQL Socket Sharing ==
2011-11-15 I had this issue using mysql :
<pre>
Could not connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
111115 22:05:40 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
111115 22:05:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
</pre>
changing bind-address in /etc/mysql/my.cnf from
bind-address = 127.0.0.1
to
bind-address = 10.100.100.220
fixed it for us. using ubuntu 11.10
:i had the same error message. my mistake was that i had no loopback-interface configured. adding
auto lo
iface lo inet loopback
:to /etc/network/interfaces and restarting networking fixed it for me. (debian)
------------
There's a good guide, using "mount --bind" available at http://sudhaker.com/2008/04/isolated-mysql-installation-openvz-cluster/, but I couldn't get it to work.
