Changes
→MySQL Socket Sharing
== 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.
