Re: [mythtv-users] mysql access problem
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 <[EMAIL PROTECTED]> 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('') where
> User='';
> FLUSH PRIVILEGES;
> exit;
>
> Mythtv should now be able to access your database again.
>
> - Ben
> ___
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
--
regards Martin West
http://www.objectgizmos.com
07879 680 096
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
On Thu, 2005-10-13 at 22:24 +0100, Martin West wrote:
> hhmm, I think I have found the problem. The default mysql installation
> 3.23.58. I have a local installation of 4.1 in /usr/local.
>
> /usr/bin/mysql -u mythtv -p
> Enter password:
> ERROR 1251: Client does not support authentication protocol requested by
> server; consider upgrading MySQL client
>
> So now have to figure how to get mythtvsetup to use my local
> installation.
The solution is http://dev.mysql.com/doc/refman/5.0/en/old-client.html
SET PASSWORD FOR 'mythtv'@'localhost' = OLD_PASSWORD('mythtv');
and add old_password to the daemon pragmas in my.cnf.
>
> On Thu, 2005-10-13 at 22:06 +0100, Martin West 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?
> >
> > ___
> > mythtv-users mailing list
> > mythtv-users@mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> ___
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
--
regards Martin West
http://www.objectgizmos.com
07879 680 096
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
On 13/10/05, Martin West <[EMAIL PROTECTED]> 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('') where
User='';
FLUSH PRIVILEGES;
exit;
Mythtv should now be able to access your database again.
- Ben
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
On Thu, 2005-10-13 at 14:34 -0700, Bruce Markey wrote: > Martin West 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. > > The "authentication protocol" error means that the current user > doesn't have permission to use X11 so no window can be created. Thanks but I dont think so. The X Window comes up. Its a mysql problem, Im trying LD_LIBRARY_PATH pointing to my mysql lib directory in usr/local > > -- bjm > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
Martin West wrote: hhmm, I think I have found the problem. The default mysql installation 3.23.58. I have a local installation of 4.1 in /usr/local. /usr/bin/mysql -u mythtv -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client Bruce Markey wrote: The "authentication protocol" error means that the current user doesn't have permission to use X11 so no window can be created. Opps, I was thinking of another problem people often rreport but this is a different error message. Never mind. See www.mysql.org for the best information regarding MySQL stuff. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
Martin West 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. The "authentication protocol" error means that the current user doesn't have permission to use X11 so no window can be created. -- bjm ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] mysql access problem
hhmm, I think I have found the problem. The default mysql installation 3.23.58. I have a local installation of 4.1 in /usr/local. /usr/bin/mysql -u mythtv -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client So now have to figure how to get mythtvsetup to use my local installation. On Thu, 2005-10-13 at 22:06 +0100, Martin West 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? > > ___ > mythtv-users mailing list > mythtv-users@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- regards Martin West http://www.objectgizmos.com 07879 680 096 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] mysql access problem
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? -- regards Martin West ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
