<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
On 3/4/2011 2:16 AM, Anthony Giggins wrote:
<blockquote
cite="mid:AANLkTimLk+QdFR9WBxO3hh4h2osQhvzptZ3MB1sRujfU@mail.gmail.com"
type="cite"><br>
<br>
<div class="gmail_quote">On 4 March 2011 10:24, Frank Phillips <span
dir="ltr"><<a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a moz-do-not-send="true"
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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
OK, when I run netstat -l |grep mysql, I get:<br>
<br>
getnameinfo failed<br>
tcp 0 0 *:mysql *:* LISTEN<br>
unix 2 [ ACC ] STREAM LISTENING 5631
/var/run/mysqld/mysqld.sock<br>
<br>
Running iptables -L returns nothing. Just goes back to the prompt.
I'm pretty sure that I have the software firewall on the backend
turned off.<br>
<br>
Any ideas?<br>
Harry<br>
<br>
</body>
</html>