Reset Password root MySQL

Reset Password root MySQL di Linux

Print PDF

Jika password root mysql lupa, dan harus reset password. Caranya cukup mudah, langkah-langkahnya begini:

#/etc/init.d/mysqld stop #mysqld_safe --skip-grant-tables #mysql --user=root mysql >update user set Password=PASSWORD('new-password') where user='root'; >flush privileges; >exit; #/etc/init.d/mysqld restart

1 2 3 4 5 6 7

#/etc/init.d/mysqld stop #mysqld_safe --skip-grant-tables #mysql --user=root mysql      >update user set Password=PASSWORD('new-password') where user='root';      >flush privileges;      >exit; #/etc/init.d/mysqld restart

Sumber  : http://www.howtoforge.com/reset-forgotten-mysql-root-password