I downloaded devkinsta and docker as per the installation tutorial but every time I try to create either a new WordPress site or a custom site the installation does not complete and it is the MySQL database step which fails (2nd step). Can anyone suggest what I need to check out/try to resolve this problem please?
Thanks @Chris_Renshaw, are you seeing this line in your logs: [Warning] Access denied for user 'root'@'localhost' (using password: YES)
You can also private message the main.log to me and upload it as an attachment.
My solution in the above thread should work in every case. It’s very hard to tell why this occurs for certain users but if you can share the main.log, I’ll ask our developers to review it as well.
That’s odd; so are you not running DevKinsta under an administrator account? That might be why.
So first I would try closing DevKinsta from the Task Manager, then running it as an Administrator. It might be able to create the root user with admin permissions.
If that doesn’t work, I can try to adapt my guide to show you how to create the root mysql users.
All that being said, if you aren’t running DevKinsta under a root/administrator user, you might run into some more issues further down the road.
docker exec -it devkinsta_reset_mariadb_root mysql mysql -e “FLUSH PRIVILEGES; CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘PASSWORD_HERE’;
CREATE USER ‘root’@‘localhost’ IDENTIFIED BY ‘PASSWORD_HERE’;
GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ IDENTIFIED BY ‘PASSWORD_HERE’;
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘PASSWORD_HERE’;FLUSH PRIVILEGES;”