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

[Another Sillyname]

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.