> > > > > 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 _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users