I’ve checked your latest
main.log file and there I still noticed this error message:
[2023-02-23 16:15:31.371] [info] [containerExec] Command ‘mysql -u root -p****** -e “create database test001;”’ on devkinsta_db finished with exit code 1
[2023-02-23 16:15:31.372] [error] [ipcMainStep] Error in operation SITE_CREATION, step database: Error: Error (1): UERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
Could you please open your Docker desktop, and move to the Containers tab, then please click the container name
devkinsta_db , and then click on the “Inspect” tab ?
After that, check on the
Environment → MYSQL_ROOT_PASSWORD section and note/write that MySQL root password shown there to your notepad or text editor for example.
Once noted, please go back to your Docker Desktop (same
devkinsta_db container) and click on the “Terminal” tab.
There, please perform this mysql command line manually (no space after
-p and replace the
YOURMYSQLROOTPASS with the actual password you noted/got from that “Inspect” tab above) :
mysql -u root -pYOURMYSQLROOTPASS -e “create database test001;”
and see if it returns any error?
Or you may also want to simply try to login to the mysql with root user, with this command line:
mysql -u root -p
you will be prompted to enter the password, and see if you can login with the MYSQL Root Password you noted/got from the Inspect tab above.
If it’s not working (and you get
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)), then it’s something with the ROOT MYSQL password related issue set in that DB container (which would prevent DevKinsta to create/manage databases in that DB container).
You may want once again close and shutdown DevKinsta completely (not just minimized) and remove/delete only the
devkinsta_db container from your Docker desktop, and retry .
If it’s still not working, I’m wondering if you have any existing sites created in your DevKinsta already? or it’s just a brand new installation (and no local sites yet)?
In case you don’t have any local sites created yet in your DevKinsta - and the mysql root password is still not working (not able to connect to the MySQL DB with the root mysql password as explained above), then I think you may want to consider to remove and clean-up DevKinsta completely (and remove any folders/data related to it, all containers, network volumes, etc.), may also want to remove/delete anything inside these folders (e.g.:
C:\Users\hadil\AppData\Roaming\DevKinsta , and
C:\Users\hadil\DevKinsta ) and start from scratch to re-install DevKinsta.