Q: DevKinsta Version
A: 1.0.1
Q: OS Version
A: Windows 10 Pro 20H2
Q: Docker Desktop Version
A: 3.1.0
Q: Were any error codes or messages observed? If so, what were they?
A: DK0033
Q: Detailed Description of the Problem
A: While trying to create my first kinsta.local domain I got this error message:
The error is linked to this page: DevKinsta Error Codes - Kinsta
But there is no such error code on that page.
There are no other MySQL instances running at this time.
I checked the docker devkinsta-db image logs and found this error:
2021-01-20 10:57:29 0 [Note] mysqld: ready for connections.
Version: '10.5.5-MariaDB-1:10.5.5+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2021-01-20 11:02:16 3 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
Also, DK tries dozens of times (30+) those incorrect username/password credentials, because I see that many such “Access defined” errors.
We’re working on a fix for this. Here’s a workaround to resolve this for the time being:
docker rm devkinsta_db
docker volume rm devkinsta_db_data
Let us know if this helps
Removing the db container and volume helped to fix this issue. Thanks.
I guess the error codes page on your site should be updated as well to include this DK0033.
Hey @slaFFik . Have you experienced any further issues on this in the last 10 months? Let us know if you’ve encountered this again. Try DevKinsta 2.3.0 as well.
Hi there,
I ran into this problem today running DevKinsta 2.4.1. When I typed in the command above, I got back the following:
Error response from daemon: You cannot remove a running container 671ca85b30580aed7e1d1df1533dff43d28291e1f8981a0a898eb80b11b50e0b. Stop the container before attempting removal or force remove
What do I do? Any help would be greatly appreciated. Thanks!
Hi @berger292, sorry for the late response here.
You can actually do all of this from within Docker.
You first need to stop the container you are trying to remove:
docker stop devkinsta_db would be how you do this from the command line.
docker rm devkinsta_db
Please let us know if that doesn’t work!
Hey @slaFFik ,
Export your site’s database with Adminer then close DevKinsta.
Run this command in terminal
“docker container rm devkinsta_db && docker volume rm devkinsta_db_data”
Now Start DevKinsta and Import Database with Adminer.
Same issue here, current version of DevKinsta, 2.4.1.
I have MariaDB and MySQL installed. MySQL is on port 3307 and MariaDB is on port 3308.
Per instructions, I exited the app, stopped the db container and removed the db & db_data containers. Upon restart, same issue.
Some net resources indicate that this error is caused by usage of the auth_plugin for authentication, which (apparently) does not allow root logins.
Via Docker Desktop, log messages, followed by login error:
2022-03-15 15:10:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-03-15 15:10:00+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-03-15 15:10:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-03-15 15:10:00 0 [Note] mysqld (mysqld 10.5.5-MariaDB-1:10.5.5+maria~focal) starting as process 1 ...
2022-03-15 15:10:00 0 [Note] InnoDB: Using Linux native AIO
2022-03-15 15:10:00 0 [Note] InnoDB: Uses event mutexes
2022-03-15 15:10:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-15 15:10:00 0 [Note] InnoDB: Number of pools: 1
2022-03-15 15:10:00 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
2022-03-15 15:10:00 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-03-15 15:10:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-03-15 15:10:00 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-15 15:10:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-03-15 15:10:01 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-15 15:10:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-15 15:10:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-15 15:10:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-03-15 15:10:01 0 [Note] InnoDB: 10.5.5 started; log sequence number 45289; transaction id 21
2022-03-15 15:10:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-15 15:10:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-03-15 15:10:01 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 15:10:01
2022-03-15 15:10:01 0 [Note] Server socket created on IP: '::'.
2022-03-15 15:10:01 0 [Warning] 'user' entry 'root@f0f30fbecb5f' ignored in --skip-name-resolve mode.
2022-03-15 15:10:01 0 [Warning] 'user' entry '@f0f30fbecb5f' ignored in --skip-name-resolve mode.
2022-03-15 15:10:01 0 [Warning] 'proxies_priv' entry '@% root@f0f30fbecb5f' ignored in --skip-name-resolve mode.
2022-03-15 15:10:01 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_transition_type' doesn't exist trying to live without them
2022-03-15 15:10:01 0 [Note] Reading of all Master_info entries succeeded
2022-03-15 15:10:01 0 [Note] Added new Master_info '' to hash table
2022-03-15 15:10:01 0 [Note] mysqld: ready for connections.
Version: '10.5.5-MariaDB-1:10.5.5+maria~focal' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2022-03-15 15:10:27 3 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-03-15 15:10:30 4 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
[ ... ]
Hi @powem, welcome to DevKinsta.
What container’s do you have running in Docker?
Does Adminer load for you? For example, in my setup it would be here: http://127.0.0.1:15200/
I also want to point out this solution that may also be relevant for you: Can't connect to database - #4 by jromero_arro