[mythtv-users] mysql access problem

[Martin West]

Yep, Thanks. Found the solution last night. You also have to add
old_password to my.cnf

The mythtv is one installed by yum following the instructions for
fedora.

On Thu, 2005-10-13 at 15:08 -0700, Ben Holt wrote:
> On 13/10/05, Martin West <martin.west at dsl.pipex.com> wrote:
> > I ran the install mc.sql OK but when I run mythtvsetup I get an error
> > saying authentication protocol not supported. I can logon using mysql -u
> > mythtv -p at a command line. Im using mysql 4.1.9 on FC3.
> >
> > Any thoughts?
> 
> It looks like your mythtv version was compiled against an older mysql
> version.  4.1 uses a different format than earlier versions.  Here's
> what you need to do:
> 
> mysql -u root -p mysql
> (enter root password)
> 
> update user SET Password=OLD_PASSWORD('<mythtv user password>') where
> User='<mythtv username>';
> FLUSH PRIVILEGES;
> exit;
> 
> Mythtv should now be able to access your database again.
> 
> - Ben
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-- 
regards Martin West
http://www.objectgizmos.com
07879 680 096