I'm trying to setup a MBE/SBE config. So reading the LinHessection and this thread sends me to comment out 'skip-networking' in /etc/mysql/my.cnf but I only see the following.



Does the LinHes setup have (need) an update? or am I missing something? Do I need to change the bind-address? or leave the file as is?

TIA

A quick search for skip-networking turned up this...
http://mysettopbox.tv/phpBB2/viewtopic.php?t=14890&highlight=skipnetworking

THanks for steering me in the right direction. This wiki entry was really current and helpful too. I was having problems with the 'skip-networking' entry and the location change from /usr/share/mythtv/mysql.txt to /etc/mythtv/mysql.txt After these changes were made, I was able to connect just fine.

I had to comment out the bind-address line to enable tapeworm to access the database from my M$ machine:



What is the implication \ consequences of this change. I think that it means any IP address can now access the database. Could I do this if I wanted to increase security:

_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4), Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB

Nope, that won't work. See http://dev.mysql.com/doc/refman/5.0/en/ ... erver.html for more details.

The bottom line is that bind-address is not primarily intended as an access control mechanism. As far as I can tell it was added as a fix for servers with multiple NICs and/or multiple IP addresses (what are often called "multi-homed" servers). It simply tells the mysql instance which IP address to listen on (bind to). Binding to the loopback interface prevents outside access as almost a side effect...

BTW - I've added known change 6.4 to the hints to cover this issue.