[mythtv-users] Goofed up root password for MySQL

IvanK. chepati at yahoo.com
Fri May 14 17:39:51 EDT 2004


Ok, here's the link:


http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

Ignore the windows stuff.

IvanK.

On Friday 14 May 2004 05:14 pm, bmcdevitt wrote:
> Greetings!
>
> Working through Jarod's install, and at Step 13 Set up MySQL, I had a
> cut and paste error to the console.
>
> I ran this command:
>
> # mysql -u root mysql
>
> got the mysql prompt.  Cut and pasted this command into the console,
> but when I pasted I had grabbed part of the next line too (mysql>
> FLUSH):
>
> mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE
> user='root';
>
> Apparently the part of the next line set the password...
>
> Not thinking anything bad had happened, I ran the next two commands:
>
> mysql> FLUSH PRIVILEGES;
> mysql> quit
>
> Now I cannot log into mysql as root, as it tells me the root password
> is bad.  I've tried all sorts of combinations of the real root
> password, no password, and the part of the line that got added in by
> accident.
>
> Is there any way to clear the root password and reset it or am I
> going to have to go the reinstall route?
>
> Thanks for your time.
>
> Regards, Bill
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


More information about the mythtv-users mailing list