Thank you for your update Dan.
Yeah, this is quite strange as you have re-installed completely and everything from scratch (I assumed you also removed everything completely as I suggested before), but you keep getting the same error (something bad happened) due to that DB root password issue as shown in that newest main.log file, such as:
[2023-03-01 14:39:40.043] [info] [containerExec] Command 'mysql -u root -p****** -e "create database local3site;"' on devkinsta_db finished with exit code 1
[2023-03-01 14:39:40.044] [error] [ipcMainStep] Error in operation SITE_CREATION, step database: Error: Error (1): UERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
So far, I have not been able to replicate the issue on my other spare computer running Windows 10 Pro (with DevKinsta 2.9.0 and Docker Desktop 4.17.0 (99724)). I’ve tried both with Hyper-V and WSL2 engine/option in Docker Desktop (WSL 2 engine is a bit slower though than Hyper-V). Note that the containers/images would need to be re-setup for each Hyper-V and WSL 2 (they are completely using different data).
I also even just now removed everything (Docker Desktop and DevKinsta) on that Windows 10 Pro machine, as I mentioned/suggested to you above, and re-installed Docker Desktop (same latest version) as well as re-installed DevKinsta 2.9.0.
But still DevKinsta was also able to create new local WP site just fine (I didn’t get MySQL root password / access denied issue at all) - that I tried with both WSL 2 and Hyper-V (I also had to restart my computer before I re-install everything from scratch) .
May I know what’s your Windows version (10/11 and if it’s Home or Pro version)? also if you’re using WSL2 or Hyper-V in your Docker Desktop 4.17.0 settings ?
Also, could you please open your Docker Desktop, click on the “Containers” tab and click on the
devkinsta_db container name.
Then, on that devkinsta_db container, click on the “Inspect” tab, and (under the “Environment” please note/copy the MySQL Root password shown there).
After that, click the “Terminal” tab there, and type this:
mysql -u root -p
When prompted to enter the password, please see if you can login there with that MYSQL ROOT Password shown in that “Inspect” tab before?
If it’s not working (failed password), then something is really not setup correctly with that Root DB password in that container.