! Rhydor
PPrisma
•Created by ! Rhydor on 5/4/2025 in #help-and-questions
Prisma P1001 Error Only on One MySQL DB (Same VPS, Sequelize Works)
Hey everyone, I’m running into a weird Prisma issue and could use some help.
I have two MySQL databases hosted on the same VPS, but on different ports:
* ✅
test DB on 106.129.20.246:3354 (works fine with Prisma)
* ❌ db DB on 106.129.20.246:3306 (fails with Prisma)
I can connect to both using Sequelize without any issues, but Prisma fails on the second one with this error:
Even though the MySQL server is running fine, and Sequelize confirms the connection.
Here’s the env for the failing one:
I've already:
* Opened port 3306 in the firewall
* Set bind-address = 0.0.0.0 in mysqld.cnf
* Verified Prisma works fine on port 3354 (Dokploy-managed MySQL)
💭 Why would Prisma fail but Sequelize work? Does Prisma do something special (like shadow DB or connection pool check) that could fail silently?
Thanks in advance!
Let me know if you want to add logs, schema snippets, or your .env config as well.8 replies