Following is mysql part of docker-compose.yml file :
MYSQL_ALLOW_EMPTY_PASSWORD : 'yes'
Now, I don't know for what weird reason, but the mysql has added "docker" as user which doesn't have access to create / drop databases. I suspect, this is because of my earlier trial setup which had user named 'docker' in it and the same is getting carried forwarded for mysql. The command 'docker-compose up -d' seems not resetting the mysql image and user "root" is not getting created.
Is there any ways I could add this user "root" ? Since don't have root access so can't even know if there is any root user added already. I tried "docker-compose exec db mysql -u root -p" with "root" as password, says access denied... with blank password, says access denied...
Any help please ?