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

Nick knowledgejunkie at gmail.com
Fri Jun 24 20:34:51 UTC 2005


On 6/24/05, Todd Bailey <toddb at toddbailey.net> 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.

When logged in to mysql as root. try the following (if you haven't already):

mysql> SELECT Host, User FROM mysql.user WHERE User='mythtv';

This should give you an idea of whether mysql will let the mythtv user
log in to the DB, and from which IP/hosname. If your machine has
changed IP or hostname, this could be the cause.

Nick


More information about the mythtv-users mailing list