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" <mythtv-users@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@mythtv.org > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
