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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s