Creating new Site, something bad happened

Q: Date/Time this occurred (Provide your time zone also)
A: 2022-10-19 12:03:37 UTC

Q: DevKinsta Version
A: Version 2.8.0 (2.8.0.5344)

Q: OS Version
A: Mac OS Monterey 12.6

Q: Docker Desktop Version
A: Docker Desktop 4.12.0 (85629)

Q: Were any error codes or messages observed? If so, what were they?
A: Something bad happened, no code

Q: Detailed Description of the Problem
A: when trying to create a new site, after configuring nginx the error message occurs. creation of new site not possible

2022-10-19 12:03:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-10-19 12:03:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-10-19 12:03:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-10-19 12:03:37 0 [Note] mysqld (mysqld 10.5.5-MariaDB-1:10.5.5+maria~focal) starting as process 1 ...
2022-10-19 12:03:37 0 [Note] InnoDB: Using Linux native AIO
2022-10-19 12:03:37 0 [Note] InnoDB: Uses event mutexes
2022-10-19 12:03:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-19 12:03:37 0 [Note] InnoDB: Number of pools: 1
2022-10-19 12:03:37 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2022-10-19 12:03:37 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-10-19 12:03:37 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-10-19 12:03:37 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-19 12:03:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-10-19 12:03:37 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-19 12:03:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-19 12:03:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-19 12:03:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-10-19 12:03:37 0 [Note] InnoDB: 10.5.5 started; log sequence number 45725; transaction id 21
2022-10-19 12:03:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-10-19 12:03:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-19 12:03:37 0 [Note] InnoDB: Buffer pool(s) load completed at 221019 12:03:37
2022-10-19 12:03:37 0 [Note] Server socket created on IP: '::'.
2022-10-19 12:03:37 0 [Warning] 'user' entry 'root@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:37 0 [Warning] 'user' entry '@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:37 0 [Warning] 'proxies_priv' entry '@% root@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:37 0 [Note] Reading of all Master_info entries succeeded
2022-10-19 12:03:37 0 [Note] Added new Master_info '' to hash table
2022-10-19 12:03:37 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-10-19 12:03:37 3 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 4 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 5 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 6 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 7 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 8 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 9 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 10 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:37 12 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:38 13 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:03:38 0 [Note] mysqld (initiated by: unknown): Normal shutdown
2022-10-19 12:03:38 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-10-19 12:03:38 0 [Note] InnoDB: FTS optimize thread exiting.
2022-10-19 12:03:38 0 [Note] InnoDB: Starting shutdown...
2022-10-19 12:03:38 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-10-19 12:03:38 0 [Note] InnoDB: Buffer pool(s) dump completed at 221019 12:03:38
2022-10-19 12:03:38 0 [Note] InnoDB: Shutdown completed; log sequence number 45737; transaction id 22
2022-10-19 12:03:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-10-19 12:03:38 0 [Note] mysqld: Shutdown complete

2022-10-19 12:03:50 0 [Note] mysqld (mysqld 10.5.5-MariaDB-1:10.5.5+maria~focal) starting as process 1 ...
2022-10-19 12:03:50 0 [Note] InnoDB: Using Linux native AIO
2022-10-19 12:03:50 0 [Note] InnoDB: Uses event mutexes
2022-10-19 12:03:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-10-19 12:03:50 0 [Note] InnoDB: Number of pools: 1
2022-10-19 12:03:50 0 [Note] InnoDB: Using ARMv8 crc32 + pmull instructions
2022-10-19 12:03:50 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-10-19 12:03:50 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-10-19 12:03:50 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-19 12:03:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-10-19 12:03:50+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2022-10-19 12:03:50+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.5+maria~focal started.
2022-10-19 12:03:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-10-19 12:03:50 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-19 12:03:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-10-19 12:03:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-10-19 12:03:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-10-19 12:03:50 0 [Note] InnoDB: 10.5.5 started; log sequence number 45749; transaction id 21
2022-10-19 12:03:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-10-19 12:03:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-10-19 12:03:50 0 [Note] InnoDB: Buffer pool(s) load completed at 221019 12:03:50
2022-10-19 12:03:50 0 [Note] Server socket created on IP: '::'.
2022-10-19 12:03:50 0 [Warning] 'user' entry 'root@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:50 0 [Warning] 'user' entry '@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:50 0 [Warning] 'proxies_priv' entry '@% root@c28bc26808b3' ignored in --skip-name-resolve mode.
2022-10-19 12:03:50 0 [Note] Reading of all Master_info entries succeeded
2022-10-19 12:03:50 0 [Note] Added new Master_info '' to hash table
2022-10-19 12:03:50 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-10-19 12:04:29 3 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2022-10-19 12:04:35 4 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

Hi @luluke1287, thanks for reaching out. The root of your issue seems to lie with mysql. For some reason the credentials aren’t matching up.

Can you please try the solutions that worked for this user: Can't connect to database - #4 by jromero_arro

There’s more troubleshooting we can do to figure out the exact cause if nothing else works.

1 Like

Hi Kevin.
Unfortunately the provided solution does not work. I’ve checked the password which is set in the container. See Screenshot.
But I still can not log in using the password which I got from the environment of the container.

2022-10-20 11:56:56 12 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

Okay, lets try completely resetting the MYSQL credentials; I’m going to write this as a general guide for other in the future as well:

  1. You will need the MySQL root password that DevKinsta is using, It should match what you are seeing there for devkinsta_db in Docker Desktop, but you can doublecheck by looking in your config.json file. Its location depends on your OS but it will be in one of the data directories listed at the bottom of the article here.

  2. We will need to create a temporary mysql container via the terminal to change the credentials/permissions with this command:
    docker container stop devkinsta_db && docker run --name devkinsta_reset_mariadb_root -v devkinsta_db_data:/var/lib/mysql/ -d mariadb:10.5.5 mysqld --skip-grant-tables

  3. Now check the mysql users with this command:
    docker exec -it devkinsta_reset_mariadb_root mysql mysql -e "SELECT Host,User FROM mysql.user"
    This is what you should see, please let me know if this is different for you:
    image

  4. This next block of code is what changes the password/privileges. Be sure to replace the four instances of PASSWORD_HERE with your password; paste this into your terminal as a single command once you change the password:

docker exec -it devkinsta_reset_mariadb_root mysql mysql -e "FLUSH PRIVILEGES; ALTER USER 'root'@'%' IDENTIFIED BY 'PASSWORD_HERE';\
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD_HERE';\
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PASSWORD_HERE';\
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'PASSWORD_HERE';FLUSH PRIVILEGES;"
  1. Remove the temporary container and restart Mariadb:
    docker rm -f devkinsta_reset_mariadb_root && docker container start devkinsta_db

Now, if this doesn’t work then it’s most likely that you are missing the root users. Please let me know if that’s the case/share what you had at step 3.

Sorry for how involved this is. We still can’t find the root cause for this issue and it does not happen for everyone. I’ll be sure our developers are aware that this is still happening for some.