Difference between revisions of "Lost MySQL root password?"
From Kolmisoft Wiki
Jump to navigationJump to search
| (One intermediate revision by the same user not shown) | |||
| Line 12: | Line 12: | ||
use mysql; | use mysql; | ||
update user set password=PASSWORD(" | update user set password=PASSWORD('''""''') where user='root'; | ||
Type your password there inside of those quotes, for example PASSWORD('''"my_new_password"''') | |||
flush privileges; | flush privileges; | ||
Latest revision as of 10:58, 13 January 2010
/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("") where user='root';
Type your password there inside of those quotes, for example PASSWORD("my_new_password")
flush privileges;
quit;
Back to previous console:
quit;
/etc/init.d/mysql restart
