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:
*
*
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
* 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
I have two MySQL databases hosted on the same VPS, but on different ports:
*
test106.129.20.246:3354*
db106.129.20.246:3306I 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.0mysqld.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