<br><br><div class="gmail_quote">On 4 March 2011 10:24, Frank Phillips <span dir="ltr"><<a href="mailto:frankalso@gmail.com" target="_blank">frankalso@gmail.com</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><br><div class="gmail_quote"><div>On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <span dir="ltr"><<a href="mailto:lifter89@comcast.net" target="_blank">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><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>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br>Sounds like mysqld is not listening on the network interface or there are firewall rules blocking it<br><br>Check what interfaces its listening on by running the command below<br><br>$ netstat -l | grep mysql<br>
tcp 0 0 *:mysql *:* LISTEN<br>unix 2 [ ACC ] STREAM LISTENING 12192 /var/lib/mysql/mysql.sock<br><br>then check the firewall by running<br><br>iptables -L | grep mysql<br>
<br>Cheers,<br><br>Anthony<br><br>