<br><br><div class="gmail_quote">On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <span dir="ltr"><<a href="mailto:lifter89@comcast.net">lifter89@comcast.net</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;">
hdevine@hdevine-faa:~$ mysql -u mythtv -p -h 192.168.1.200<br>
Enter password:<br>
ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.1.105'<br>
(using password: YES)<br>
<br>
Using the mysql client on the master be, I printed out the values in the<br>
user table of the mysql database:<br>
<br>
mysql> select Host,User,Password from user where user='mythtv'\g<br>
+---------------+--------+-------------------------------------------+<br>
| Host | User | Password |<br>
+---------------+--------+-------------------------------------------+<br>
| localhost | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |<br>
| % | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |<br>
| 192.168.1.105 | mythtv | 9b9890430520b16e39afb3698ded2eb0 |<br>
+---------------+--------+-------------------------------------------+<br>
3 rows in set (0.00 sec)<br></blockquote><div><br>A quick google suggests doing a select password('password'); to compare the hashes. Note that there are different hashes for '%' and '192.168.2.105'. You may be using the former and it is trying to authenticate against the latter.<br>
Try getting in from 192.169.1.200 (localhost) as the mythtv user.<br><br>You are talking with the daemon, so its not a blocked port, and the grant tables (grant/flush privileges) shouldn't affect your ability to login, AFAIK.<br>
</div></div>