[mythtv-users] mysql hates me... (still no luck)

clemens at dwf.com clemens at dwf.com
Sun Dec 24 07:00:59 UTC 2006


> > Database error was:
> > Access denied for user 'mythtv'@'MythTV.dwf.com' (using password: YES)
> 
>  Your grant line didn't include the wildcard character % so you say the user mythtv had to come from ".dwf.com" and not "%.dwf.com".
> 
Mumph.
Well, I would have never seen that,- I was so sure of what I typed.

But, since that iteration, 
    (a) I have typed the line in anew, no luck.
    (b) I have started over, no luck.
Im not sure what the correct way is to blow away the database, just in case 
there
is some bad data there, but I did remove the directory 
/var/lib/mysql/mythconverg
which doesnt have much in it...
    (c) and started over.
The host name has been variously MythTV and mythtv.  This hasnt confused 
anything else, but mabe mythtv... So I changed it to lower case everywhere and
rebooted.  Same problem.  Its probably time to stop working on this tonight,-
but here is the last typescript of the top of mythtv-startup.  Its still not 
connecting.

---

[mythtv at mythtv ~]$ mythtv-setup
2006-12-23 23:48:17.603 Using runtime prefix = /usr/local
2006-12-23 23:48:17.607 DPMS is active.
2006-12-23 23:48:17.614 New DB connection, total: 1
2006-12-23 23:48:17.619 Unable to connect to database!
2006-12-23 23:48:17.619 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'mythtv.dwf.com' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open

---

any additional thoughts on what stupid things I must be doing would
be appreciated.


-- 
                                        Reg.Clemens
                                        reg at dwf.com




More information about the mythtv-users mailing list