Thanks for your response.
I just found the solution on MySql forum and it is working with version 8.0
The solution is as follows
Execute the following query in MYSQL Workbench
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
Where root
as your user localhost
as your URL and password
as your password
Then run this query to refresh privileges:
flush privileges;