On 6/24/05, Todd Bailey <[EMAIL PROTECTED]> 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 _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
