[mythtv-users] Installing only mythfrontend on Ubuntu

[Harry Devine]

On 01/05/2011 08:13 PM, Clay wrote:
> Harry Devine wrote:
>> ...
>>>
>> I just upgraded my laptop to 0.24 (its what I'm trying to get the new 
>> mythfrontend working on).  I did what you suggested above, but I 
>> still can't login to the BE using "mysql -u mythtv -p -h 
>> 192.168.1.200".  On the master BE, when I examine the user table, I 
>> get the following:
>>
>> mysql> select host,user,password from user;
>> +---------------+------------------+-------------------------------------------+ 
>>
>> | host          | user             | 
>> password                                  |
>> +---------------+------------------+-------------------------------------------+ 
>>
>> | localhost     | root             | 
>> *D874BA45BF4C7839679016184F6DEDAA604D15F4 |
>> | king          | root             | 
>> *D874BA45BF4C7839679016184F6DEDAA604D15F4 |
>> | 127.0.0.1     | root             | 
>> *D874BA45BF4C7839679016184F6DEDAA604D15F4 |
>> | localhost     | debian-sys-maint | 
>> *202BB8560091FA4A1F40203C4A6D9A4FA68A6931 |
>> | localhost     | mythtv           | 
>> *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
>> | %             | mythtv           | 
>> *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
>> | localhost     | phpmyadmin       | 
>> *CE7ADEA6DBCF7D159F5A1E59B6A902BED60419AE |
>> | 192.168.1.105 | mythtv           | 
>> *CC8F35F587CA5A556B4132C2407E556D92172FFC |
>> +---------------+------------------+-------------------------------------------+ 
>>
>> 8 rows in set (0.00 sec)
>>
>>
>> It looks like it should be allowing access from my laptop, but 
>> apparently its not.  So what should I do from here to get this working?
>>
>> Thanks,
>> Harry
>
> I see you have phpmyadmin installed.
> Can you log in to the DB from your slave with phpmyadmin using root 
> and root's pw?
> I've found using phpmyadmin to juggle users and permissions much 
> easier than blindly throwing terminal commands at mysql.
> With phpmyadmin you can copy a user (IP) that works (..1.200) to a new 
> username and IP.
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
I was able to get it working by updating the mysql user table on the 
master BE to include my laptop's IP and user.  The frontend came up 
after I did the initial setup.  Playback of a recording was slow, but 
its due to the fact that I'm on a wireless connection.  The other PC 
that I wanted to put mythfrontend on is a desktop that is wired on my 
LAN, so I'm not worried.  I was using my laptop to get the procedure down.

Thanks to everyone for their help!
Harry