changing mysql root password, and adding password to ~/.my.cnf, needs to...

... happen as single transaction. Both need the same when clause