Difference between revisions of "Lost MySQL root password?"
From Kolmisoft Wiki
Jump to navigationJump to search
| Line 1: | Line 1: | ||
/etc/init.d/mysql stop | |||
# mysqld_safe --skip-grant-tables & | # mysqld_safe --skip-grant-tables & | ||
[1] 2429 | [1] 2429 | ||
| Line 20: | Line 22: | ||
quit; | quit; | ||
/etc/init. | /etc/init.d/mysql restart | ||
Revision as of 07:19, 17 September 2008
/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
