Using v1 at the moment is very brave and we expect there to be some issues, MySQL / MariaDB is also not supported in v1.0 so it would be worth using Postgres which is supported.
The error itself is a permission issue and could be related to the securityContext, can you try removing those and see if that helps?
I originally was using 0.226.2 and got the same results. I can’t use postgres as I’m trying to use it with vitess mysql. I removed and added the security context and doesn’t seem to change anything.
With the 0.226.2 version and no security context and using the mysql env, it still crashes but I get the following
So the good news there is the error is different, Can you remove all of the MySQL options and see if using SQLite works that will then show if the error is related to the database connection or not.
Yeah using SQLite works normally. I can connect to mysql from a container with the client and the same credentials. I also printed the environment vars from n8n in the short window before it crashed and it had the same details.
Perfect so I suspect the host, username or password is wrong. I am not sure why we don’t log the error anymore as it was very helpful when it said what the issue actually was. It could also be that it can’t connect to the database or the user doesn’t have the correct permissions.
Now you have n8n running with sqlite it might be worth trying the MySQL node with the same database credentials to see if that can connect. It may all be for nothing now though as we will be dropping mysql so you would need to migrate to postgres. You could also just keep using sqlite depending on what you are planning to use n8n for.
It is mostly down to time and resources when comparing it to the amount of users actually running n8n with it. By removing support for it we can then spend that time working on new features, improving testing and stability and maybe look at utilising features Postgres offers more closely without having to think of workarounds for other database platforms.