If you're doing it from the command line, try these steps.<br><br>1) Log in to the mysql shell as root with this command:<br><br>mysql -u root -p<br><br>2) Enter the mysql root password when prompted<br><br>3) Select the mysql table with this command:<br>
<br>use mysql<br><br>4) Query the user table with this command (don't forget the semicolon on the end of the query):<br><br>SELECT user,host FROM user;<br><br>5) If you don't have a row that has "mythtv" in the user column and either "macMini" or "%" (the mysql wildcard) in the host column, you can create that user with this command:<br>
<br>CREATE USER mythtv@macMini IDENTIFIED BY [whatever password your mysql.txt or config.xml file uses]<br><br>6) Grant that user permissions to use the mythconverg DB with this command:<br><br>GRANT ALL on mythconverg.* TO mythtv@macMini<br>
<br>7) Flush privileges<br><br>Of course, all of this raises a very important question that smarter people than I will have to address ... why, when the backend or mythtv-setup is trying to start, is it trying to connect to the hostname macMini rather than localhost? That's really the root of the problems (it's not something I've seen before...my backend just connects with mythtv@localhost), and may have to eventually be addressed if you're ever planning on adding additional backends or frontends. I take it this is actually installed on a macMini? If so, is it on OS X or did you install linux onto your Mini? I guess it's possible that, if you're actually running it on OS X, there's something with how that OS handles hostnames that is messing with Myth... <br>
<br>I hope this helps in any way.<br><br>Best,<br>Jarom<br><br><div class="gmail_quote">On Fri, May 22, 2009 at 4:33 PM, Mark Knecht <span dir="ltr"><<a href="mailto:markknecht@gmail.com">markknecht@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">On Fri, May 22, 2009 at 3:26 PM, Jarom McDonald <<a href="mailto:jarom_mcdonald@byu.edu">jarom_mcdonald@byu.edu</a>> wrote:<br>
> The one piece of information you haven't provided yet are the details of<br>
> your mysql user tables on the non-working and the working servers. Remember<br>
> that a mysql user is a combination of a username and a hostname, so<br>
> mythtv@localhost and mythtv@macMini and <a href="mailto:mythtv@192.168.1.61">mythtv@192.168.1.61</a> are 3 separate<br>
> users (even if, on the OS level, they all resolve to each other). The error<br>
> message you're getting on MacMini is not a Myth error, but a MySQL error<br>
> telling you that the mythtv@macMini user has been denied access. There are<br>
> only three reasons for this: 1) mysql isn't configured to accept any users<br>
> not from the 'localhost' host, 2) the password in mysql.txt isn't<br>
> corresponding with the password in the mysql tables, or 3) the mysql@macMini<br>
> user doesn't even exist.<br>
><br>
> You've ruled out 1 and 2, but haven't ruled out 3. In your mysql user table,<br>
> ("SELECT user,host FROM user") you have a mythtv@localhost (evident from<br>
> your very first message that let you connect), and you have a<br>
> <a href="mailto:mythtv@192.168.1.61">mythtv@192.168.1.61</a> (that was created when you did the GRANT statement), but<br>
> you should check to see if you have a mythtv@macMini, and that ITS password<br>
> is properly set, since that's the user that mythbackend is trying to connect<br>
> with. You could just do:<br>
><br>
> GRANT ALL on mythconverg.* to mythtv@macMini IDENTIFIED BY "[password]"<br>
><br>
> just as you did with the user that has the ip address as the hostname, to<br>
> insure that the user exists with the right password.<br>
><br>
> If THAT fails, then I don't know what to say ... there could be some<br>
> corruption in the mysql user tables. You could delete all users and<br>
> re-create them, I suppose, or drop the DBs and reinstall mysql (you did say<br>
> this was a new server, correct?)<br>
><br>
> Jarom<br>
><br>
<br>
</div></div>Jarom,<br>
It is a completely new server with no recordings. I'm free to do<br>
anything. I'll be using my HD Homerun with this server and taking the<br>
older PVR-150 server out of service as Comcast ramps down analog<br>
transmission.<br>
<br>
I'm completely happy to remove every database and start over if it<br>
makes a difference. That way at least there shouldn't be so many<br>
questions about what's been done to the database.<br>
<br>
What is the actual command I use in mysql to check this? I'd like<br>
to check before I issue a new GRANT ALL. I think I'd learn something<br>
important.<br>
<br>
I suspect that mythtv@macmini has not been accounted for.<br>
<div><div></div><div class="h5"><br>
- Mark<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>