Starting with the MySQL 8.0.4, they have changed the default authentication plugin for MySQL server from mysql_native_password to caching_sha2_password.
You can try running the below command to resolve the issue.
sample username / password => student / pass123
ALTER USER 'student'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass123';
You can refer the official page for details: MySQL Reference Manual
If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.