… Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.
Open another terminal and login to mysql: sudo mysql
then execute the following command to set a password.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'PASSWORD_HERE';
Also read: Install WordPress (LAMP) On CentOS 8