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';