Q: Date/Time this occurred (Provide your time zone also) A:03:31 - IST 4/2/2022 - Mumbai / Kolkata
Q: DevKinsta Version A:Latest 2.4.0.2956
Q: OS Version A:Windows 10 Pro 64
Q: Docker Desktop Version A:Latest 4.4.4.73704
Q: Were any error codes or messages observed? If so, what were they? A:DK0033 (Constant - Still Persistent - Unable to Authenticate Database Manually) and DK009 (Does Not Persist after Re-Install Docker Desktop and DevKinsta)
Q: Detailed Description of the Problem A:Create New Site via DevKinsta does not function as expected. The product needs improvement
Hello @weskyprint, welcome to DevKinsta!
I too use Windows 10 Pro but have never gotten these errors. BOth seem to be because of Docker Desktop, though. We have solutions for each code here: DevKinsta Error Codes - Kinsta®
However, can you try force closing DevKinsta then Clen/Purge data within Docker(assuming this is a brand new install and you don’t mind completely resetting)? After that see if DevKinsta will start correctly/create the containers.
Hey Kevin, thank you for the run through. It took me about 4 hours last night to work on a solution to setup DevKinsta and get it to work correctly but with no luck.
After reading through all the articles tagged with the Error Code DK0033 - Cannot connect to Database I tried the following -
Disable and completely drop UAC on Windows
Uninstall Firewall and Antivirus
Set Inbound Rules on Firewall granting access to specific ports as displayed in Docker Desktop
Remove and Reinstall container and images along with DevKinsta via Windows Command Prompt
Constant Error at Container Level - maria_db - Unable to authenticate due to wrong password.
Unable to change Password for the respective container via CLI for maria_db_database inspite of whats reflected on DevKinsta as the password
This is really frustrating for a user to move across the native AWS to container ecosystem.
I’m gonna purge data now and try getting it to work if it may!
Alright, so after digging deeper with troubleshooting, I have realised this needs to be manually setup from our end on each installation
When faced with an Error DK00033 - Inside Logs you will find that maria_db password needs to change
Click on maria_db inside of Docker Desktop and Open the CLI
Enter the command mysql -u root -p and enter the password
Enter the command
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
SET PASSWORD = PASSWORD(‘changethistodevkinstapasswordwithquotes’);
You will need to replace changethistodevkinstapasswordwithquotes with Password in Site Info inside DevKinsta
Hence the new command will look like
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
SET PASSWORD = PASSWORD(‘UPizk43xJuouD0pX’);
Click Retry and it will complete the install process.
"Below you should enter your database connection details. If you’re not sure about these, contact your host.
Database Name
wordpress
The name of the database you want to use with WordPress.
Username
username
Your database username.
Password
password
Your database password.
Database Host
localhost
You should be able to get this info from your web host, if localhost doesn’t work.
Table Prefix
wp_
If you want to run multiple WordPress installations in a single database, change this."
PROBLEM -
Error establishing a database connection
It seems like something is definitely off in the initial setup phase. Is your hosts file even getting modified correctly by Docker? Your new site shouldn’t be accessible from 127.0.0.1 or at least that should redirect you to an actual domain with a .local TLD. It almost sounds like it’s not being installed with administrator privileges but I’m not 100% certain based on your errors.
Is Docker conflicting with some other local environment you have set up now or in the past?
Can you do a factory setting reset of Docker then start DevKinsta. I assume you’ll get the same errors but can you get us a copy of the main.log? On Windows it ends up in C:\Users\username\AppData\Roaming\DevKinsta\logs