Hi guys, quick question - I have access to a datab...
# orm-helpa
Ashwin Kudva
07/27/2020, 4:11 PMHi guys, quick question - I have access to a database in a MySQL box that I want to have Prisma introspecting/connecting to, but don't have access to make new databases. However, it seems as though Prisma needs to make a new database called 'prisma' to store its metadata. Is there any way to change this or redirect the tables it needs to create to the database I do have access to?
r
Richard Ward
07/27/2020, 7:16 PMIt shouldn't need a new database - it should use your existing one..
a
Ashwin Kudva
07/27/2020, 7:37 PMit seems as though it tried to make a new database called 'prisma' to store its own metadata
Ashwin Kudva
07/27/2020, 8:16 PMthe error is
Exception in thread "main" java.sql.SQLSyntaxErrorException: (conn=4316845) Access denied for user '****'@'%' to database 'prisma'Ashwin Kudva
07/27/2020, 8:16 PMand it's cased by a database creation query: `Query is: CREATE SCHEMA IF NOT EXISTS
prismar
Richard Ward
07/27/2020, 8:19 PMWhat is your connection string in your
schema.prismaa
Ashwin Kudva
07/27/2020, 9:05 PMare you talking about prisma-schema.js? when i run
prisma initAshwin Kudva
07/27/2020, 9:15 PMi've specified a host, database, user, and pass in my docker-compose.yml file. It connects to the database, that's not the issue. If I try doing the same thing in Docker instead of on a production MySQL box, I see that it generated a 'prisma' database when starting up
Ashwin Kudva
07/27/2020, 9:15 PMis there a way to not have to do that?
r
Ryan
07/28/2020, 6:23 AMHey @Ashwin Kudva đź‘‹
You are using Prisma 1, I guess it will need a user that has full access to the database, the one that you pass in your
docker-compose.ymldocker-compose.ymla
Ashwin Kudva
07/28/2020, 3:00 PMSure
Ashwin Kudva
07/28/2020, 3:02 PMAshwin Kudva
07/28/2020, 3:04 PMI am using Prisma 1, and unfortunately I cannot have a user create a database. Is this something that can be avoided if I migrate to Prisma 2?
r
Ryan
07/29/2020, 6:55 AMFull access to the database, not access to creating one. You can create the db and pass into your
docker-compose.yml