MythTV + mysql problems

[Paul Lussier]

"Adam (gnhlug)" <gnhlug at thehelblings.com> writes:

> All,
>
> So I am in the process of setting up my mythtv machine. I have run in to a
> problem where I cannot login to my mysql database. I am following the steps
> on wilsonet.com/mythtv/, but it appears that once I performed this step.
>
> # mysql -u root mysql
> mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
> mysql> FLUSH PRIVILEGES;
> mysql> quit
>
> with my desired password, and tried to then run, $ mysql -u root -p <
> /usr/share/doc/mythtv-0.20/database/mc.sql
>
> I get the error:
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)

Most databases allow users from specific hosts.  You allowed root
access with a password, but didn't specify whence root is allowed to
connect.  There probably need to be multiple root entries specifying
the hosts root is allowed to connect from.  Check out the online mysql
docs, they're quite complete and very good.

-- 
Seeya,
Paul
--
Key fingerprint = 1660 FECC 5D21 D286 F853  E808 BB07 9239 53F1 28EE

A: Yes.                                                               
> Q: Are you sure?                                                    
>> A: Because it reverses the logical flow of conversation.           
>>> Q: Why is top posting annoying in email?