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

David Campbell dave at cpfc.org
Fri Apr 20 07:24:12 UTC 2007


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


More information about the mythtv-users mailing list