[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).
More information about the mythtv-users