Follow : https://devanswers.co/install-apache-mysql-php-lamp-stack-ubuntu-20-04/
Common Errors :
- 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.
- Solution : Login as root, sudo mysql, ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password by ‘yourpassword’;