[SOLVED] Upgraded Lenny to Squeeze: mythtv can't connect to mysql

Quakeboy02 · 02-13-2011, 12:26 PM

The upgrade actually went pretty well, except for what looks like a new "feature" to mysql-server-5.1. But I post here, because the issue seemed to be in "/etc/hosts" file. If it should really be somewhere else, feel free to move it. Specifically, the problem is during configuration of mythtv-database I get the following:

Code:

ERROR 1045 (28000): Access denied for user 'root'@'musem.local' 
(using password: YES)

**********************
There is something I've never quite understood about /etc/hosts. This has been the first two lines of my file since I upgraded to Lenny. My machine name is "musem", of course.
file: /etc/hosts

Code:

127.0.0.1       localhost
127.0.1.1      musem

In order to get this mythtv/mysql issue resolved, I had to change to the following:

Code:

127.0.0.1       localhost
#127.0.1.1      musem
192.168.1.76    musem

The problem is that I don't understand what this means. What potential problems do I have without a "127.0.1.1"? Or could this have been effected by some change to the "users" table in mysql?

NOTE: This mythtv server "musem" is my main machine, and is being remotely accessed by the Linux box next to my TV.

Quakeboy02 · 02-13-2011, 12:37 PM

I hate answering my own questions, but perhaps putting the question down on LQ organizes it for me such that I can do a better search. In any case, the answer for what "127.0.1.1" does (and why my changed fixed the problem) was posted by win32sux here. Why this is suddenly necessary with mysql-server-5.1 is an entirely different question.

http://www.linuxquestions.org/questi...1/#post3067894