Hello again @harmione_johnsson 
I’ve checked the main.log file you shared to my colleague Alessandro, and indeed I could see from the log, it’s the same error due to the mysql root password (incorrect), such as follow for example:
[2023-03-31 13:05:16.002] [info] [ProgressIndicator] { isFailed: false, isOpen: false }
[2023-03-31 13:05:15.868] [error] [ipcMainStep] Error in operation SITE_CREATION, step database: Error: Error (1): UERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
And in that main.log file, I also noticed these lines (which seem normal for the initial setup):
[2023-03-31 12:58:12.087] [info] [containerExec] Command 'mysql -u root -p****** -e "SHOW DATABASES;"' on devkinsta_db finished with exit code 1
[2023-03-31 12:58:32.601] [info] [configureDatabaseUser] Database root password is missing or incorrect, resetting it.
[2023-03-31 12:58:32.653] [info] [dbResetScripts] DB reset SQL file created at C:\Users\dhara\AppData\Local\Temp\mariadb_reset.sql.
[2023-03-31 12:58:32.655] [info] [dbResetScripts] DB reset Shell script file created at C:\Users\dhara\AppData\Local\Temp\mariadb_reset.sh.
[2023-03-31 12:58:32.657] [info] [dockerUtil/createContainer] Create 'devkinsta_reset_mariadb_root' container
Then the DB root password reset (.sh script file) had been executed many times there, but all returned with " finished with exit code 1 " (means there’s an error) like these for examples:
[2023-03-31 12:59:10.194] [info] [containerExec] Command 'bash /tmp/mariadb_reset.sh' on 39defdd905f1ae2f1f988112cdcd4fc2e6d02ebb2e0d4b646f6e5defe38ff3e9 finished with exit code 1
[2023-03-31 12:59:11.867] [info] [containerExec] Command 'bash /tmp/mariadb_reset.sh' on 39defdd905f1ae2f1f988112cdcd4fc2e6d02ebb2e0d4b646f6e5defe38ff3e9 finished with exit code 1
[2023-03-31 12:59:13.643] [info] [containerExec] Command 'bash /tmp/mariadb_reset.sh' on 39defdd905f1ae2f1f988112cdcd4fc2e6d02ebb2e0d4b646f6e5defe38ff3e9 finished with exit code 1
I also have tried on my Windows 10 pro machine once again today/just now:
-
I completely deleted/removed the DevKinsta and it’s files/folders under my folders: “C:\Users\iagus\AppData\Roaming\DevKinsta” and “C:\Users\iagus\DevKinsta” , and also I deleted all devkinsta_*
Containers, Images and Volumes in my Docker Desktop.
-
After that I re-installed DevKinsta, and after waited for some time (downloaded / setup the required containers), and so far I could create new site just fine - no DB error issue.
-
I also checked my main.log
file and there, I could see similar logs as yours (which seem to be normal for the initial setup) :
[2023-04-03 11:42:55.613] [info] [containerExec] Command 'mysql -u root -p****** -e "SHOW DATABASES;"' on devkinsta_db finished with exit code 1
[2023-04-03 11:43:06.040] [info] [configureDatabaseUser] Database root password is missing or incorrect, resetting it.
[2023-04-03 11:43:06.067] [info] [dbResetScripts] DB reset SQL file created at C:\Users\iagus\AppData\Local\Temp\mariadb_reset.sql.
[2023-04-03 11:43:06.068] [info] [dbResetScripts] DB reset Shell script file created at C:\Users\iagus\AppData\Local\Temp\mariadb_reset.sh.
[2023-04-03 11:43:06.069] [info] [dockerUtil/createContainer] Create 'devkinsta_reset_mariadb_root' container
in my case, the mariadb_reset.sh script, that was initiated to reset the DB root password, could be completed with the " finished with exit code 0 " (means no error)
[2023-04-03 11:43:07.448] [info] [containerExec] Command 'bash /tmp/mariadb_reset.sh' on 1b9f30071c5b5adaf0d075f6a650e71a47b045e01168c35b9f8be0aa82975266 finished with exit code 0
I’m still not sure why on your computer, that DB password reset process didn’t return with the " exit code 0
" (means no error) but " exit code 1
" (has an error).
and so far I couldn’t replicate the issue on my end either.
Just would like check and confirm if your “dhara” Windows user account has an Administrator access on your Windows 11 machine?
Also, maybe try to check if you have any firewall, windows defender, anti-virus or something like that, and may want to try to temporary disable them all and retry?
I’m wondering what if you try the following (I tried the same on my end and could do these just fine) :
- Open your Docker Desktop, click on “Containers” tab on the left side then click on the
devkinsta_db
name.
- On the
devkinsta_db
page, click on the “Inspect” tab , and write down/copy the value of “MYSQL_ROOT_PASSWORD” (this should be the root password for MySQL) shown there to notepad or something .
- On that same
devkinsta_db
page, click on the “Terminal” tab, and type the command:
mysql -u root -p
- When prompted with the password “Enter password:” , please enter the password you noted on step 2 above.
- See if it could accept that password? or is it also showing “Access denied for user root” as well ?
Cheers,
Agus