database base user permission issues | Prisma | Page 1

jovial knoll Mar 12, 2024, 11:50 AM

#

please can anyone assist me to fix this issue
#1111711591575064648

solemn prism Mar 12, 2024, 12:12 PM

#

Hey @jovial knoll 👋

You need to grant permissions to user "sql_eliteexchang" to create a shadow database.

Could you grant them the permissions and then try to invoke npx prisma migrate dev command?

#

You could grant permissions to a user through this SQL:

GRANT CREATE ON *.* TO 'username'@'hostname';

*.* signifies all databases and all tables within those databases on the MySQL server

jovial knoll Mar 12, 2024, 12:38 PM

#

yes i did this since, but it did not work

#

#

#database base user permission issues