[mythtv-users] Can't set mysql root password for host_name

[Carl Foner]

>2010/1/23 Michael T. Dean <mtdean at thirdcontact.com>:
>>  On 01/23/2010 04:40 PM, Carl Foner wrote:
>>>  I'm having trouble setting up mysql on a MacOS X box. I've 
>>>successfully set up
>>>  a mythbox before using KnoppMyth, but this is my first time 
>>>having to do much
>>>  mysql fiddling.
>>>
>>>  I'm following the instructions at
>>>  http://www.mythtv.org/wiki/MythTV_on_Mac_OS_X. So far so good, but I can't
>>>  past a certain point.
>>>
>>>  I deleted the anonymous accounts by using
>>>
>>>  DROP USER '';
>>>
>>>  (they had listed just DROP USER ; which didn't work)
>>>
>>>  I'm at the point where I'm setting up root passwords. I was able to
>>>  successfully do
>>>
>>>  SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
>>>
>>
>>  GRANT first, then only use SET PASSWORD to change password (as you set
>>  the initial password with a GRANT).
>>
>>  MIKE
>>  _______________________________________________
>>  mythtv-users mailing list
>>  mythtv-users at mythtv.org
>>  http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>
>Or install mysql-gui tools for OSX, saves you having to learn too much
>of the syntax.
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

GRANT worked. Thanks. I'll check out the mysql-gui tools for the future.