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

Michael T. Dean mtdean at thirdcontact.com
Sat Jan 23 22:37:54 UTC 2010


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


More information about the mythtv-users mailing list