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?
--[[User:Hvdkamer|Hvdkamer]] 08:23, 2 August 2006 (EDT)
: If you want to link to the Category:HOWTO, you put it like this
: <code><nowiki>[[:Category:HOWTO HOWTOs (i.e. this is link text)]]</nowiki></code>
== 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.
This is with Ubuntu Hardy (fixed kernel from Git).
[[User:Blueyed|Blueyed]] 16:23, 28 April 2008 (EDT)
=== Decreased security ===
Isn't sharing sockets blocking advantages promoted in <blockquote>"As an extra security measure you can use the internal IP-address as well."</blockquote>
I'd actually would like to have mysql reject root user logins unless logging in from VE actually housing mysql server. That's impossible on using Unix sockets since it's always using "localhost" then, isn't it?