[mythtv-users] Problems with new setup???

[Per Jørgensen]

David Watkins wrote:
> On 16/10/2008, Per Jørgensen <myth at pbj-design.dk> wrote:
>   
>> David Watkins wrote:
>>     
>>>> Afterwards I'm testing the DB - with this command:
>>>> # mysql -p -u mythtv
>>>> Enter password:
>>>> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
>>>> password: YES)
>>>>
>>>>
>>>>         
>>> You need to get this working.
>>>
>>> It looks like a permissions (PRIVILEGE) issue to me but I can't really
>>> read you database tables in my mail reader.
>>>
>>>       
>> I've tried - using this link as source
>> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
>>     
>
> I presume you mean you used this command to set the privileges?
>
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> mysql> flush privileges;
>
> have you tried replacing % with localhost?
>
> I'm not the best person to help you with this because I got into a
> mess when I changed my network settings and took ages to get the
> permissions working again without really understanding what I was
> doing.  I kept finding examples of the above command using different
> arrangement of the quotation marks.  It also took be a long time to
> realise that 'identified by' means 'using password'.  At least I think
> it does.
>   

Actually I was using this line:

Finally, if you just want to restrict by IP subnet (in this example, the 
192.168.1. network):

    ||

    $ mysql -u root mythconverg
    mysql> grant all on mythconverg.* to mythtv@"172.16.20.%" identified by "mythtv";
    mysql> flush privileges;

    Which is my actual networksettings. 
    Since I'm running with 3 frontends - I'm needing to contact from the subnet! 
    But identified is the actual passwd you'll need to use. Thats also why I'm confused and don't understand why this ain't working

    Per 


      

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