<div dir="ltr">On Thu, Jul 11, 2013 at 3:00 PM, Mike Perkins <span dir="ltr"><<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>></span> wrote:<br><div class="gmail_extra">
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">On 11/07/13 18:48, Thomas Mashos wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
On Thu, Jul 11, 2013 at 10:42 AM, Enno Middelberg <<a href="mailto:enno.middelberg@gmail.com" target="_blank">enno.middelberg@gmail.com</a><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
wrote:<br>
</blockquote>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
Hello,<br>
<br>
<br>
2013/7/10 Jon Heizer <<a href="mailto:jheizer@gmail.com" target="_blank">jheizer@gmail.com</a>>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
$ mysql -u root mythconverg<br>
mysql> grant all on mythconverg.* to mythtv@"%" identified by<br>
</blockquote></blockquote></blockquote>
"mythtv";<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
mysql> flush privileges;<br>
</blockquote>
<br>
I tried this, but didn't go anywhere:<br>
</blockquote></blockquote>
<br>
Ok, so I have tried this now:<br>
<br>
mysql -u root -p mythconverg<br>
Enter password:<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 121<br>
Server version: 5.5.28-1 (Debian)<br>
<br>
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights<br>
reserved.<br>
<br>
Oracle is a registered trademark of Oracle Corporation and/or its<br>
affiliates. Other names may be trademarks of their respective<br>
owners.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
statement.<br>
<br>
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> flush privileges;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> quit<br>
<br>
<br>
sudo /etc/init.d/mysql restart<br>
[sudo] password for enno:<br>
[ ok ] Stopping MySQL database server: mysqld.<br>
[ ok ] Starting MySQL database server: mysqld ..<br>
[info] Checking for tables which need an upgrade, are corrupt or were<br>
not closed cleanly..<br>
<br>
sudo /etc/init.d/mythtv-backend restart<br>
Restarting MythTV server: mythbackend No /usr/bin/mythbackend found<br>
running; none killed.<br>
.<br>
.<br>
<br>
Cannot login to database<br>
<br>
Would you like to configure the database connection now? [no]<br>
[console is not interactive, using default 'no']<br>
<br>
<br>
<br>
So this looks pretty much like what I had started with. What can I do<br>
to get this going?<br>
<br>
</blockquote>
<br>
<br>
Might want to set the password for the mythtv user in the database, then<br>
fix it in config.xml<br>
<br>
</blockquote>
That's what the "grant all" operation does. It sets the password for the mythtv user to "mythtv".<br>
<br>
Now I recall that ubuntu, like debian, likes to think up some new password combination when you install mythtv. Perhaps that's what happened here.<span class=""><font color="#888888"><br>
<br>
-- <br>
<br>
Mike Perkins<br>
<br>
______________________________<u></u>_________________<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/<u></u>listinfo/mythtv-users</a><br>
</font></span></blockquote></div><br></div><div class="gmail_extra">You're right, I didn't look up the password change syntax as I thought I remembered it correctly. Whoops.</div><div class="gmail_extra"><br></div>
<div class="gmail_extra">The password is only set on install for the mythtv user, shouldn't be reset. And even then, he manually reset the password on it (which IMO is the wrong way to do it on ubuntu/debian). Perhaps he should check /home/mythtv/.mythtv/config.xml and see if the right password exists there.</div>
<div class="gmail_extra"><br clear="all"><div>Thanks,<br><br>Thomas Mashos</div><br><br></div></div>