[mythtv-users] Debian install: MySQL problem

Tim tim.hoebeek at gmail.com
Tue May 17 20:18:43 UTC 2005


> > > > > How about /etc/mythtv/mysql.txt?
> > > >
> > > > In /etc/mythtv/mysql.txt:
> > > > same login and password as in row 6 (mythtv user in MySQL)
> > > Can you login with mysql from the command line with the username and
> > > password ?
> >
> > Yes, I can with the root account, but I can't with the mythtv account.
> >
> > I tried resetting the password in two ways:
> > SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('mythical');
> > ERROR 1133: Can't find any matching row in the user table (documented bug)
> >
> > update mysql.user set password=password('mythical') where user='mythtv';
> >
> > but still I can't login with that account.
> >
> > This makes me think there's something wrong with my query or MySQL,
> > but I don't know which... Any ideas?
> 
> Did you reload the privs after you added the new user? Try restarting MySQL

I'm *really* ashamed now. I did forget to reload the privileges *blush*

So, probably the script needs a password for root, but I'm not even
sure anymore...


Thanks a lot for the help everyone,
Tim


More information about the mythtv-users mailing list