Lost MySQL root password?

From Kolmisoft Wiki
Revision as of 12:36, 1 October 2008 by Mindaugas (talk | contribs)
Jump to navigationJump to search

/etc/init.d/mysql stop

mysqld_safe --skip-grant-tables &
[1] 2429
morgui:~# Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[2466]: started

Window hangs, we go to other console

mysql -u root
use mysql;
update user set password=PASSWORD("password") where user='root';
flush privileges;
quit;

Back to previous console:

quit;
/etc/init.d/mysql restart





http://www.debianhelp.co.uk/mysqlroot.htm