[mythtv-users] Debian install: MySQL problem

Tim tim.hoebeek at gmail.com
Mon May 16 18:19:09 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?


Cheers,
Tim


More information about the mythtv-users mailing list