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