[mythtv-users] Database setup
Harry Devine
lifter89 at comcast.net
Sun Mar 23 03:21:54 UTC 2008
Michael Nguyen wrote:
> 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
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Damn, I thought we had it! I ran "mysql -u root -p <
/usr/share/doc/mythtv-docs-0.21/database/mc.sql" and got "Access denied
for user 'root'@'localhost' (using password: YES)". So I'm in the same
boat. Any other areas I should be looking at? Damn, this is frustrating!
Thanks,
Harry
More information about the mythtv-users
mailing list