[mythtv-users] Database setup

[Harry Devine]

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