<div class="gmail_quote">On Fri, Aug 6, 2010 at 5:35 PM, R. G. Newbury <span dir="ltr"><<a href="mailto:newbury@mandamus.org">newbury@mandamus.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Use mythtv-setup -> general to ensure that the box is talking to the correct place, then take a look at the mysql settings table, and in particular look out for duplicate instances of a 'value' field and that the hostname field is correct. You should also check any mysql.txt or config.xml files for the correct address.. and finally, check that mysql 'likes' you, by using the user@domain authentication for the mysql console or check the /var/lib/mysql/mysql/user table entries for host,user and password fields. phpMyAdmin is great for this if you are not comfortable using the mysql console and SQL commands.<br>
<br>
<div><div class="h5"><br></div></div></blockquote><div><br>can you specify the relevant tables and fields? I took a look and couldn't find any duplicates or problems with the IP addresses. Also, do you mean mythtv@localhost for the domain? I don't think I have a domain set up:<br>
<br>mythtv@tv:/mnt> mysql -u mythtv@localhost -p<br>Enter password:<br>ERROR 1045 (28000): Access denied for user 'mythtv@localhost'@'localhost' (using password: YES)<br><br></div></div><br>