I know I am a bit late to the party, but just in case someone else is having trouble with this specific problem the following might be a solution:
In my case the root password wasn’t set, so I just had to set it manually in docker. The following steps is how I fixed it.
- Open docker desktop and navigate to “Containers”
- Open the devkinsta_db container
- Navigate to the inspect tab
- Find the
Configsection - Copy the root password under the config section; it should something like this:
"Config": {
"Hostname": "a912727155a0",
"Domainname": "",
"User": "",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"3306/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"MYSQL_ROOT_PASSWORD=***kinsta root password***",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"GOSU_VERSION=1.14",
"MARIADB_MAJOR=10.5",
"MARIADB_VERSION=1:10.5.17+maria~ubu2004"
- Navigate back to the container sections
- Open the DB terminal
- Log into mariadb using
mysql -u root
If the root password wasn’t set then you should get a mysql prompt - Set the password to your kinsta root password:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password copied from the config';
If successful you should get the following responseQuery OK, 0 rows affected (0.020 sec)
Now you should be able to get past the error.
