[captainperl]

There are several ways to update the root password in MySQL with zero down-time, either by manipulating the user table, using replication, or using other accounts (ie. most people grant excessive privileges to role accounts.)

https://www.percona.com/blog/2014/12/10/reset-mysql-root-pas...