I can't start n8n on a fresh database

[Yasirunet]

Hey @phpguru, @Jon

Has anyone found any solution to this problem with the Digital Ocean hosted MySQL database?
Having the same issue with DO hosted MySQL database.

Thanks in advanced

[phpguru]

DO’s MySQL version is too new. I had to install my own MySQL 5.7 on a droplet.

[Yasirunet]

Thanks for the reply @phpguru. But the thing is um tested it with lates mysql docker container and all work fine. That seem strange. Just as you mentioned it create some tables on the database as well. (That implies no problem with connecting to the DB)

@Jon Any thoughts?

[phpguru]

It’s been awhile so maybe it wasn’t the MySQL version but the DO-managed MySQL requires a connection encrypted by TLS whcih N8N doesn’t do yet?

I was not able to use the DO-managed MySQL, was my main point. I just created my own droplet (even though I would’ve much preferred to use the managed service) because my assignment was time sensitive.

[jan]

Glad to hear that you found a solution. But as mentioned here I would strongly recommend to use Postgres instead of MySQL:

Docker | problem to create tables in mysql version 5.5.60

Welcome to the community @josimarrocha0197! Very sorry not have much to say right now to solve your actual problem, but something else that is maybe helpful. Do not try to get it to work with MySQL and rather set up Postgres. The reasons behind that are mainly: That is the database (apart from SQLite) that most of our users use, we do the most testing, you will have the least amount of issues with (for the previously mentioned reasons), and will find more people to be able to help you I am c…

[Yasirunet]

@phpguru

because my assignment wa

Hey @jan
Do u have any insight about what the reason it’s not working with Digital Ocean Managed MySQL? I’ve tested it with latest MySQL docker container and it was working fine.
Since it’s creating some tables on the DB seems the connection also fine. What is wrong with migrations?

Um really eager to hear your thoughts : ) Thanks in advanced!

[jan]

Sorry, do sadly have no idea. Honestly do not have any deep knowledge about MySQL and even less about the managed version of Digital Ocean. So can sadly not be of any help here except my above recommendation not to use it.