[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