[mythtv-users] mythfilldatabase: Access denied for user
dave at taro.homeip.net
Tue Oct 5 01:59:45 UTC 2004
I'm using the Debian packages for Myth. I just finally upgraded to 0.16,
and I broked mythfilldatabase. In the past, I was playing with mysql and
ended up changing the password for root. As a result, mythtv-database
failed to upgrade properly. Whoops! I removed the password again, and
completed the upgrade.
Now, myth runs fine, but mythfilldatabase isn't able to update the
database. The relevant output seems to be:
DB Error (Creating temporary table):
CREATE TEMPORARY TABLE IF NOT EXISTS dd_station ( stationid char(12), callsign char(10), stationname varchar(40), affiliate varchar(25), fccchannelnumber char(15) );
Driver error was [2/1044]:
QMYSQL3: Unable to execute query
Database error was:
Access denied for user: 'mythtv at localhost' to database 'mythconverg'
I'm able to use the mysql client to connect to mythconverg as mythtv,
using the password in /etc/mythtv/mysql.txt, so I'm not really sure what
the problem could be.
Is there any way that I can figure out what password mythfilldatabase is
trying to use?
Thanks for your help,
More information about the mythtv-users