Resetting MySQL Root Password


Quary
Resetting MySQL Root Password

Stopping MySQL Service
service mysql restart
(or)
service mysqld restart

Run This Command
mysqld_safe –skip-grant-tables &

Open MySQL
mysql -u root mysql

Change Root Password
mysql> use mysql;
mysql> UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
mysql> exit

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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