<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Henrik Beckman wrote:
<blockquote
cite="mid:af2e95fa0903080329s10e9af9ds9ad5e125013d3a22@mail.gmail.com"
type="cite">
<pre wrap="">snip
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">mysql> SELECT `Host`,`User`,`Password` FROM `user` WHERE `User` = 'mythtv';
Check to see if the password hashes are the same for all occurences of
the mythtv user, and that you have any entry for localhost.
</pre>
</blockquote>
<pre wrap="">mysql> select `Host`,`User`,`Password` from `user` WHERE `User` = 'mythtv';
+---------------+--------+-------------------------------------------+
| Host | User | Password |
+---------------+--------+-------------------------------------------+
| localhost | mythtv | *07B8126C2DD7B5C86540517EEC78CC3AC92C9FA8 |
| % | mythtv | *07B8126C2DD7B5C86540517EEC78CC3AC92C9FA8 |
| 192.168.1.% | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+---------------+--------+-------------------------------------------+
</pre>
</blockquote>
<pre wrap=""><!---->
snip
</pre>
<blockquote type="cite">
<pre wrap="">So everything worked which is good. So I added the host 192.168.1.%
back - this time with the correct password and everything still works.
Which leads me to the question, how do I get rid of the '%' host for
mythtv? If I do "drop user 'mythtv'@'%';" won't I loose all of the
hosts including localhost and 192.168.1.% since the '%' is a wildcard?
Or in this case am I specifying host equal to '%' where this time '%'
is understood as char and not the wildcard? Anyway, would rather not
wipe out my database ;)
--
~pAul.
</pre>
</blockquote>
<pre wrap=""><!---->
I can´t get mythweb to work and for me % is the problem,
mysql> select `Host`,`User`,`Password` from `user` WHERE `User` = 'mythtv';
+-------------+--------+-------------------------------------------+
| Host | User | Password |
+-------------+--------+-------------------------------------------+
| localhost | mythtv | ok |
| % | mythtv | wrong |
| 192.168.1.% | mythtv | ok |
| 192.168.0.% | mythtv | ok |
+-------------+--------+-------------------------------------------+
4 rows in set (0.00 sec)
% mythtv has the wrong password =(
/Henrik
</pre>
</blockquote>
You can either use the webinterface from webmin or anything like it to
set the passwd again.<br>
Otherwise you can use the command - UPDATE from commandline.<br>
Something like UPDATE TABLE USER SET PASSWORD="New passwd" WHERE
Host="%"; <br>
<br>
<blockquote
cite="mid:af2e95fa0903080329s10e9af9ds9ad5e125013d3a22@mail.gmail.com"
type="cite">
<pre wrap="">_______________________________________________
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://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
<br>
</body>
</html>