Reset mysql password

/etc/init.d/mysql stop
mysqld --skip-grant-tables &
mysql -u root
FLUSH PRIVILEGES;
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
FLUSH PRIVILEGES;
exit
/etc/init.d/mysql stop
/etc/init.d/mysql start

Leave a Reply

Your email address will not be published. Required fields are marked *