Edit

Description

ALTER USER 'root'@'localhost' IDENTIFIED BY '{{ OLD_PASSWORD }}'; uninstall plugin validate_password; ALTER USER 'root'@'localhost' IDENTIFIED BY '{{ NEW_PASSWORD }}';

Option

MySQL 5.7 Remove validate password plugin

Script