[mythtv-users] MacOSX MySQL Errors

Eric Robinson ryunokokoro at gmail.com
Thu Sep 27 00:09:56 UTC 2007


David Brodbeck wrote:
> On Sep 26, 2007, at 4:06 PM, Eric Robinson wrote:
>
>   
>> Brad DerManouelian wrote:
>>     
>>> Try to log in using the MySQL client from a remote machine on your
>>> network and see what the error message is.
>>>       
>> What kind of commands would I use for that?  I must confess that I'm a
>> mysql noob.
>>     
>
> mysql -h 192.168.0.1 -u mythtv -p
>
> Replace "192.168.0.1" with the correct IP for your backend host, and  
> "myth" with whatever username you're using for MythTV.  You'll be  
> prompted for the password.
>
> The machine you try this from will need the MySQL client installed.   
> In most distributions this is in a package called "mysql-client" or  
> something similar.
>   

Okay, I ran the command above.  This is what I get for an error:

The-Great-Owl:/usr/local/mysql/bin Eric$ ./mysql -h 192.168.10.136 -u
mythtv -p
Enter password:
ERROR 1045 (28000): Access denied for user
'mythtv'@'The-Great-Owl.local' (using password: YES)


The-Great-Owl is my system's name.  I'm running this on Mac OSX 10.4.10.

Thoughts?  Is it the last part?  I changed the permissions on the
backend mysql server to use IP values, not the system names.  Do I need
to add that too?  Or is there a way to force MythTV to connect with just
IP info?  Is that even the issue?


More information about the mythtv-users mailing list