B.5.4.1 How to Reset the Root Password - MySQL

If you have never set a root password for MySQL, the server does not require a ... The UPDATE statement resets the password for all root accounts, and the ...

dev.mysql.com