When running `prisma migrate dev --preview-feature...
# prisma-migrate
p
When running
prisma migrate dev --preview-feature
with prisma 2.14.0, I get the following error:
Copy code
Error: A migration failed when applied to the shadow database:
P3006
Migration `20210128090300_init` failed to apply cleanly to a temporary database. 
ERROR 42000 (1142): ALTER command denied to user
I think the problem is that the database user does not have the required access to the shadow database. Only granting
CREATE, DROP ON *.*
like stated in the docs, seems to be not sufficient.
✔️ 1
j
Hi Pascal, we’ll double check that soon and let you know, it’s possible that the docs needs to be updated
Looks to me that
CREATE, ALTER, DROP ON *.*
permissions should do it
p
Thanks, I just granted all permission for now, which solves the problem.
👍 1