Difference between revisions of "Lost MySQL root password?"
From Kolmisoft Wiki
Jump to navigationJump to search
(Replacing page with 'http://www.debianhelp.co.uk/mysqlroot.htm') |
|||
| Line 1: | Line 1: | ||
# 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.t/mysql restart | |||
<br><hr><br> | |||
http://www.debianhelp.co.uk/mysqlroot.htm | http://www.debianhelp.co.uk/mysqlroot.htm | ||
Revision as of 10:41, 4 April 2008
# 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.t/mysql restart
