[mythtv-users] How to connect a FE to a remote BE

[Glen Hawksworth]

Hi again,
Ok I did what it said under "Modifying access to the MySQL database for
multiple systems" with respect to restricting to my IP subnet and I also
edited /etc/mysql/my.cnf to change the bind-address IP from 127.0.0.1 to
my server IP.
I restarted the PC (because I couldn't figure out how to restart mysql)
and I tried connecting from the remote front end again. This time the FE
actually took some time before saying fail when I tried to test the
connection.
Is it possible that I don't have a database set up? I followed the
instructions during install to have a separate front end but it doesn't
seem to have configured much for me. How would I find out if I have a
database?

Notes:
      * I can ping both ways
      * the password that I am using is from /etc/mythtv/mysql.txt
      * I have allowed access privileges to all on my subnet
      * I cannot connect from my frontend box to my backend's mysqld
        with ay variation of the following ("mysql -h <backend-ip>")

On Thu, 2007-11-15 at 08:56 +1100, glenhawk at optusnet.com.au wrote:
> 
> 
> 
> > Marc Sherman <msherman at projectile.ca> wrote:
> > 
> > On Nov 14, 2007 2:54 PM, Glen Hawksworth <glenhawk at optusnet.com.au> 
> > wrote:
> > >>
> > >> Access denied for user 'root'@'localhost' (using password: NO)
> > >>
> > >> now I know the password but don't know where to put it or how to 
> > include
> > >> it in that line (mythtv told me that a root password was a good idea 
> > and
> > >> let me set one so I do know the root password)
> > 
> > Craig Huff wrote:
> > > 
> > > Try this:
> > > $ mysql -u root -pPASSWORD mythconverg
> > > 
> > > Where PASSWORD is replaced by whatever you set the mysql password to.
> > > Note that there is *no* space between the -p switch and the password 
> > text.
> > 
> > That's bad advice. If you do that, you'll end up with your password 
> > stored in the clear in your bash history file.
> > 
> > It's better to use just -p (without the password), which will cause the 
> > mysql client to prompt you for the password at launch.
> > 
> > - Marc
> > _______________________________________________
> 
> Thanks again guys, I will try this when I get home.
> Fair point about the localhost, Craig. I was thinking that localhost was an alias for my IP address (when on the server) and that I would just have to use my IP address from the remote FE.
> I'll chase it down eventually :-)
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>