[mythtv-users] What to do when you can't remember the password for mysql

[Keller Giacomarro]

On Fri, 2007-04-20 at 08:24 +0100, David Campbell wrote:
> The correct way
> 
> stop mysql
> 
> /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
> mysql -u root
> use mysql;
> UPDATE user SET Password=PASSWORD("somepassword") WHERE User="root";
> 
> start mysql
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Told you there was a more elegant way. =)