[mythtv-users] mysql issue when accessing backend from a remotefrontend

[Andy Barr]

On 8/20/06, Brad DerManouelian <myth at dermanouelian.com> wrote:
> On Aug 20, 2006, at 8:22 PM, Andy Barr wrote:
>
> >>
> > I just noticed that my xbox is running mysql client 4.0.22 but my
> > backend is running mysql 5.0.  Could this be causing the issue?
>
> Most certainly is. At some point mysql changed the way passwords were
> handled. Best thing would be to update the client, but if you poke
> around google for old password support, there's a command you can
> issue on the server side to use the old-style passwords. It might
> even be OLD_PASSWORD("password") instead of just "password". Can't
> remember off the top of my head what it is, though.

You were 100% correct.  I did this on my server and it fixed the problem,
mysql -u root -p mythconverg
mysql> SET PASSWORD FOR mythtv at 192.168.2.50 = OLD_PASSWORD('mythtv')
I can now run mythtv on my xbox and access my Ubuntu backend.
Thanks for all the help.