MySQL Admin Password Issue


MySQL Admin Password Issue
Reseting lost MySQL Admin Root password in Linux

Stopping MySQL Service
service mysql stop

Starting MySQL Server Without Password
mysqld_safe –skip-grant-tables &

Login MySQL
mysql -u root

Setup MySQL New Password
use mysql;
UPDATE user SET password=PASSWORD(“NEW-ROOT-PASSWORD”) WHERE User=’root’;
FLUSH privileges;
quit

Re-Starting MySQL Service
service mysql restart

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