Authentication error while fetching data but not while prisma studio or db push
I am getting an authentication error in prisma saying the credentials are not valid while fetching some data in nextjs. but I can use "prisma db push", prisma studio with the same credentials. Can anyone help?
5 Replies
Hi @Mikail
If you have special characters in your password for example
@, you will need to percent encode it as shown in this section of the documentationConnection URLs (Reference) | Prisma Documentation
Learn about the format and syntax Prisma ORM uses for defining database connection URLs for PostgreSQL, MySQL and SQLite.
Nope
A similar error was shown in this previous Github discussion and it turns out the user had special characters in the password. Can you please confirm that the password does not contain any special character?
GitHub
unable to connect mysql database in prisma client · prisma prisma ·...
Hi Prisma community I have a problem with mysql connection database the env url is env Url is: DATABASE_URL="mysql://root:password@localhost:3306/nextapp" the prisma Schema as simple as t...
I am 100% sure I don't have a special charecter in my password
Can you please confirm that you can connect to a database client like Table Plus (https://tableplus.com/) using the connection string
TablePlus | Modern, Native Tool for Database Management.
Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, and Redis.