Freitag, 8. August 2008

MySQL: Rest Password SuSE

- Run level and stop mysql
su:
password:
- /usr/bin/mysqld_safe --skip-grant-tables &

in another terminal:
mysql -u root -p
update user set Password=PASSWORD('new-password-here') WHERE User='root';

flush privileges;
exit;

return to first terminal:
fg
ctrl + c or z

/etc/init.d/mysql start
mysql -u root -p

Keine Kommentare: