[mythtv-users] Database setup
Michael Nguyen
michaeln at twentyten.org
Sun Mar 23 02:54:26 UTC 2008
Harry Devine wrote:
[snip]
> OK, I just did the 2 commands above and verified that
> /var/lib/mysql/mysql exits. Before I take the next step (and hose
> something up AGAIN), I want to be sure I have the correct initialization
> procedure for mythconverg. I was going to use the one found here:
> http://www.mythtv.org/wiki/index.php/User_Manual:Initial_Installation.
> Is this right? Are there any portions of that that I don't need to do?
> Lastly, once this is back to normal, I can put the user back to mythtv
> in the first setup screen, correct?
>
> Thanks again for everything! Very much appreciated!
> Harry
>
The only thing you need to do is recreate the mythconverg database:
mysql -u root -p < /usr/share/mythtv/database/mc.sql
Now that you know the "root" user password for MySQL, this command
should work. And yes, put the user back to "mythtv" once you do this.
Also, I know we're past this at this point, but I looked back on the
thread and you seemed to have been able to connect via root. You said that:
1) mythtv-setup worked as "root"
2) You were able to "drop database mythconverg;"
At this point it doesn't matter, but there definitely has been a
disconnect here.
Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080322/95c4f853/attachment.htm
More information about the mythtv-users
mailing list