[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:
>>     
>>> 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
>>     
>
> Can you connect to mysql from a remote machine?
>   
Yes using root.
> Can you connect to mysql locally as a different user?
>   
yes also as the user root
> Is your hosts file or DNS setup correct?
>   
It is.

> It was changing my subnet that got me into the same situation that you
> seem to be in.  I started to come to the conclusion that the format of
> the Grant commnad has changed since that wiki page was written, but I
> don't know.  I did get it working in the end :-) somehow.
>
> Maybe someone who understands this stuff can chime in?
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   
As far as I see - the problem is about granting the permissions.
Even with a grant all - all privileges says N (in my belive no)
So even mysql> grant all on mythconverg.* to mythtv@"%" identified by 
"mythtv";
Query OK, 0 rows affected (0.00 sec)
stil gives me N in all privileges - damn !