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
######################
[EMAIL PROTECTED]:~$ 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: '[EMAIL PROTECTED]' (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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
