[mythtv-users] Debian install: MySQL problem

Tim Sailer tps at buoy.com
Tue May 17 03:28:40 UTC 2005


On Mon, May 16, 2005 at 08:19:09PM +0200, Tim wrote:
> > > > 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

Tim

-- 
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
 >> Tim Sailer                      ><  Coastal Internet, Inc.         <<
 >> Network and Systems Operations  ><  PO Box 726                     <<
 >> http://www.buoy.com             ><  Moriches, NY 11955             <<
 >> tps at buoy.com                    ><  (631) 399-2910  (888) 924-3728 <<
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<


More information about the mythtv-users mailing list