These commands assume the backend machine is running ubuntu (or some form of *buntu like mythbuntu)
Code:
sudo dpkg-reconfigure mythtv-database
Answer 'yes' in the obvious place.
That should give database access to the network. restart the mysql server
Code:
sudo service mysql restart
and then run the code to test where it is listening again:
Code:
sudo netstat -tanp |grep 3306
you should now see it listening on 0.0.0.0 - ie all network addresses.
Now we need to get mythbackend to listen on your lan address. Make sure you know your backend computer's LAN IP address. Then start mythtv-setup and go into the first option. On the first page there should be two spaces to enter the IP address, they are probably set to 127.0.0.1. Change them to the LAN IP address and click through the next buttons, and you'll get back to the main mythtv-setup screen. Esc to exit, don't bother to run mythfilldatabase if it asks you.
Test again with the line from my earlier post
Code:
sudo netstat -tanp|grep myth|grep LISTEN
You should now see it listening on your LAN IP.