Mysql Root password reset

Follow the steps tp proceed with mysql root password reset

#service mysqld stop

#/usr/bin/mysqld_safe –skip-grant-tables &

#mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD(’new_password’) WHERE user=’root’

mysql> FLUSH PRIVILEGES;

mysql> exit;

#service mysqld start

Advertisements