[mythtv-users] mythfilldatabase: Access denied for user

Dave Steinberg dave at taro.homeip.net
Tue Oct 5 01:59:45 UTC 2004

Hi all,

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):
Query was:
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 mailing list