[mythtv-users] Installation database problems

[Ray Olszewski]

I had a similar problem when I frist set up MythTV (using the Debian-Sid 
prepackaged version). Although I got it working, I did so much futzing 
around to make it work that I don't think I can describe how to do it 
properly. But this question does come up again and again. Is there any 
possibility that someone who actually understands this part (I'm trying to 
exclude *me* here ... not *you*, Ben) could write it up in a systematic way?

By systematic, I mean with all the details, including common errors and 
what to do about them. For example, Ben's explanation below omits any 
indication of whether to execute those commands as root, as mythtv, or as 
someone else.

I apologize for simply asking someone else to do some work. Plain truth is, 
I don't understand mysql well enough to do this for the docs. But I think 
it is badly needed. MythTV users shouldn't have to become mysql experts (or 
do people disagree with that view?) just to record TV.

At 07:07 PM 5/14/2003 +0200, Ben Bucksch wrote:
>softsecure at vivace.homelinux.net wrote:
>
>>>Unable to open database:
>>>Driver error was:
>>>QMYSQL3: Unable to connect
>>>Database error was:
>>>Access denied for user: 'mythtv at localhost' (Using password: YES)
>>>
>>Any guesses for what I might need to do to start using mythtv?
>Did you set up the database, if the RPMs didn't do that for you? usually, 
>that's as easy as
>mysql < mc.sql
>or
>mysql -uroot -pyourpassword < /usr/whatever/mc.sql
>
>If you already did that, then the access rights for user mythtv are not 
>set up properly. A look in /var/log/mysql.-log might help, as well as 
>reading the MySQL docs about giving user rights.
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at snowman.net
>http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users