Solved by changing the authentication method of user default to mysql native password.
Go to mysql bash docker-compose exec mysql bash
login using root mysql -u root -p password is root.
then issue following mysql command ALTER USER 'default' IDENTIFIED WITH mysql_native_password BY 'secret';