[mythtv-users] Installing only mythfrontend on Ubuntu

[Clay]

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 
______________________________________________________________________