== 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)
I probably did something stupid, but how can I link from the HOWTO's to this page?
: 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 found it was a good idea sharing the MySQL Socket instead of had this issue using TCP/IP. (which is also <b>ALOT</b> faster)mysql :
<pre>
# 101 is the Could not connect to database: Can't connect to local MySQL Server VEx (debian 4.0)# 102 Another VEx (opensuse 10.0)ln /var/lib/vz/private/101server through socket '/var/run/mysqld/mysqld.sock ' (2) 111115 22:05:40 [ERROR] Can't start server: Bind on TCP/var/lib/vz/private/102/var/run/mysqld/IP port: Cannot assign requested address 111115 22:05:40 [ERROR] Do you already have another mysqld.sockserver 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
The result<pre>opensuse:/ # mysql i had the same error message. my mistake was that i had no loopback-u root -p -S /var/run/mysqld/mysqldinterface configured.sockaddingEnter password: auto loWelcome to the MySQL monitor. Commands end with ; or \g.iface lo inet loopbackYour MySQL connection id is 9 :to server version: 5/etc/network/interfaces and restarting networking fixed it for me.0.32(debian)-----------Debian_7etch1-log
Type There'help;s a good guide, using "mount --bind" available at http://sudhaker.com/2008/04/isolated-mysql-installation-openvz-cluster/, but I couldn' or t get it to work.Also the "ln /var/lib/vz/private/101/var/run/mysqld/mysqld.sock ..." mentioned in the article itself does not work for me: the mysqld.sock only appears in /vz/root/123, not /vz/private/123.Additionally, "mysql -u root -p -S /vz/root/123/var/run/mysqld/mysqld.sock" fails with: ERROR 2002 (HY000): Can'\ht connect to local MySQL server through socket ' for help/var/lib/vz/root/1234/var/run/mysqld/mysqld. Type '\csock' to clear the buffer(111)This is with Ubuntu Hardy (fixed kernel from Git).[[User:Blueyed|Blueyed]] 16:23, 28 April 2008 (EDT)
mysql=== 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."</preblockquote>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?
