[mythtv-users] Any troubleshooting info available for mysql &myth?

Todd Bailey toddb at toddbailey.net
Mon Jun 27 18:24:30 UTC 2005



Thanks to all who offered their assistance on this one.


I finally tracked this down to the stored password in mysql became 
corrupted.
Once I cleared it and reset it to a known value, mythtv was able to 
communicate with mysql from a non root account.

How and why this happened will probably remain a mystery,  but something to 
add to the knowledgebase in case any one else ever  has this issue crop up.






----- Original Message ----- 
From: "Korey Fort" <k.m.fort at gmail.com>
To: "'Discussion about mythtv'" <mythtv-users at mythtv.org>
Sent: Friday, June 24, 2005 1:53 PM
Subject: RE: [mythtv-users] Any troubleshooting info available for mysql 
&myth?


>
> http://dev.mysql.com/doc/mysql/en/mysql-database-administration.html
> Sections 5.6 and 5.7 are on Privileges and User Accounts.
> What your looking to do is change or add permission to a database.
> mysql -u root -p{if you have one).
> use mysql;
> SELECT ALL FROM users WHERE username="mythtv"; #If I remember correctly.
> Then you grant privileges to mythtv.
> Don't follow what I said word for word. I haven't looked at it myself and
> haven't played with any tables in months, but 5.{6,7} ought to be able to
> help you.
>
>
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Todd Bailey
> Sent: Friday, June 24, 2005 2:37 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Any troubleshooting info available for mysql
> &myth?
>
> Thanks,
>
> but been there done that.
>
>
> ----- Original Message ----- 
> From: "Kevin Kuphal" <kuphal at dls.net>
> To: "Discussion about mythtv" <mythtv-users at mythtv.org>
> Sent: Friday, June 24, 2005 12:34 PM
> Subject: Re: [mythtv-users] Any troubleshooting info available for mysql
> &myth?
>
>
>> Todd Bailey wrote:
>>
>>> Hi All,
>>>
>>> I am looking for some general purpose t/s info on mysql.
>>> I've been running myth for about a week now and just recently, the 
>>> setup,
>
>>> frontend and backend need to be run as root in order to gain access to
>>> the mysql db. File and directory as well as database permissions appear
>>> ok, however when I try to run as the myth user I get errors something to
>>> the effect of mysql access denied.
>>> I'm assuming it's a security/permissions issue, either at the
>>> file/directory level or internal to mysql.
>>> I don't have any problems or concerns running myth as root but would
>>> rather not.
>>>
>>> I've already checked and (re) executed the setup scripts, reinstalled
>>> mysql and checked mysql.org documentation for clues on what is wrong.
>>> So far every thing appears as it should be.  I'll eventually determine
>>> the problem but if anyone has had this occur, any hints/suggestions 
>>> would
>
>>> be welcome.
>>>
>> Check here: http://www.mythtv.org/docs/mythtv-HOWTO-6.html
>>
>> Kevin
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>


--------------------------------------------------------------------------------


_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



More information about the mythtv-users mailing list