[mythtv-users] My MySql hell :-)

Peter Abplanalp pta-myth at psaconsultants.com
Fri Mar 9 20:23:11 UTC 2007

----- Original Message ----- 
From: "Damian Surr" <damian at gingermagic.co.uk> 
To: "Discussion about mythtv" <mythtv-users at mythtv.org> 
Sent: Friday, March 9, 2007 12:59:47 PM (GMT-0700) America/Denver 
Subject: [mythtv-users] My MySql hell :-) 

> Database error was: 
> Access denied for user 'mythtv'@'' (using password: YES) 

this error says that you do not have access to that account from that host. i.e. the mythtv client is telling the mysql server that 'mythtv' is connecting from '' and mysql is telling you that mythtv is not allowed to connect to the service from 

what you need to do is allow access from you can do this by logging in to the mysql server using the root account and running the following command: 

flush privileges; 
whatever you use for 'some_pass' needs to be in the mysql.txt file. you can make it easy and use 'mtythtv'. 

> $ mysql -u root mysql 
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> password: NO) 

this is a problem. you probably won't be able to update the user table with the mythtv account. i do not know what default password you get with your distro; however, on some it is just blank. you can try a simple <enter> when prompted for a password. 

Peter Abplanalp 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070309/4da1e991/attachment.htm 

More information about the mythtv-users mailing list