Recover MySQL Password

Linux January 28th, 2010

#/etc/init.d/mysql stop
#mysqld_safe –skip-grant-tables &
#mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(’passwd-baru’) where User=’root’;
mysql> flush privileges;
mysql> quit
#/etc/init.d/mysql stop
#/etc/init.d/mysql start
#mysq -u root -p

Sumber:

http://harba.polsri.ac.id/?p=27

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

mysqld_safe –skip-grant-tables &

Tags: ,