[mythtv-users] myth-setup faliure on Ubuntu 5.04

[Michael T. Dean]

edward morrow wrote:

> When I try to run the myth-setup the tv screen flashes for a moment 
> but fails and the following is the output
> ######################
> onekind at umans:~$ mythtv-setup
> 2005-10-16 16:53:45.623 Unable to connect to database!
> 2005-10-16 16:53:45.624 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user: 'mythtv at localhost' (Using password: YES)
>
> couldn't open db
> ...
> I have setup the root password in the Mysql and a mythtv client has 
> been added with the following.
> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";

 From http://dev.mysql.com/doc/refman/4.1/en/access-denied.html :

If you cannot figure out why you get |Access denied|, remove from the 
|user| table all entries that have |Host| values containing wildcards 
(entries that contain ‘|%|’ or ‘|_|’). A very common error is to insert 
a new entry with |Host|=|'%'| and |User|=|'/|some_user|/'|, thinking 
that this allows you to specify |localhost| to connect from the same 
machine. The reason that this does not work is that the default 
privileges include an entry with |Host|=|'localhost'| and |User|=|''|. 
Because that entry has a |Host| value |'localhost'| that is more 
specific than |'%'|, it is used in preference to the new entry when 
connecting from |localhost|! The correct procedure is to insert a second 
entry with |Host|=|'localhost'| and |User|=|'/|some_user|/'|, or to 
delete the entry with |Host|=|'localhost'| and |User|=|''|. After 
deleting the entry, remember to issue a |FLUSH PRIVILEGES| statement to 
reload the grant tables.

Mike