Did that before I started complaining, from the file<br>in the mythtv source tree, as instructed by the manual.<br><br>mysql --user=root < database/mc.sql<br><br><div class="gmail_quote">On Sun, Dec 21, 2008 at 9:13 PM, Owen Townend <span dir="ltr"><<a href="mailto:owen.townend@gmail.com">owen.townend@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;">2008/12/22 the mad doctor kaeding <<a href="mailto:the.mad.doctor.kaeding@gmail.com">the.mad.doctor.kaeding@gmail.com</a>>:<br>
<div class="Ih2E3d">> echo 'show databases;' | mysql --user=root --password<br>
> gives<br>
> ....<br>
> mysql<br>
> mythconverg<br>
> .....<br>
><br>
> echo 'show tables;' | mysql --user=mythtv --password=mythtv<br>
> --database=mythconverg<br>
> gives a blank line<br>
><br>
> creating /etc/mythtv/mysql.txt with the right stuff in it<br>
> had no effect.<br>
><br>
<br>
</div>Hey,<br>
<br>
The blank line from the 'show tables' command shows that the database<br>
exists but is empty.<br>
Your password/credentials all worked fine though which is a good start<br>
though they may not have the right to alter the table.<br>
Try this to double check that the user and database are set up correctly.<br>
(First check that mc.sql exists there, it may be elsewhere depending<br>
on your distro)<br>
`mysql --user=root --password < /usr/share/mythtv/sql/mc.sql`<br>
then try mythtv-setup again.<br>
<br>
cheers,<br>
<font color="#888888">Owen.<br>
</font><div><div></div><div class="Wj3C7c">_______________________________________________<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>