How to quickly reset mysql’s root password

ps aux | grep mysql

/usr/sbin/mysqld –skip-grant-tables &

UPDATE mysql.user SET Password=PASSWORD(‘NeWPaSSwOrD’) WHERE User=’root’;

FLUSH PRIVILEGES;

 

——

EDIT:

try this:

mysqladmin -u root password NEWPASSWORD

Leave a Reply

Your email address will not be published.

Loading Facebook Comments ...
Loading Disqus Comments ...