[mythtv-users] Installing only mythfrontend on Ubuntu
Clay
ctmythtv at pacbell.net
Thu Jan 6 01:13:06 UTC 2011
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
______________________________________________________________________
More information about the mythtv-users
mailing list