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" <[EMAIL PROTECTED]>
To: "'Discussion about mythtv'" <[email protected]>
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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
To: "Discussion about mythtv" <[email protected]>
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
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
--------------------------------------------------------------------------------
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
