centos\mysql

vi  mysql_security_commands.sql

Database name:

Database password:

SET @@old_passwords=1;

UPDATE mysql.user SET Password=PASSWORD('ABC123xyz') WHERE User='root' and plugin='mysql_old_password';

SET @@old_passwords=0;

UPDATE mysql.user SET Password=PASSWORD('ABC123xyz') WHERE User='root' and plugin in ('', 'mysql_native_password');

SET @@old_passwords=2;

UPDATE mysql.user SET authentication_string=PASSWORD('ABC123xyz') WHERE User='root' and plugin='sha256_password';

Database name: