P
Prisma3mo ago
Mikail

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?
No description
No description
No description
No description
5 Replies
RaphaelEtim
RaphaelEtim2mo ago
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 documentation
Connection URLs (Reference) | Prisma Documentation
Learn about the format and syntax Prisma ORM uses for defining database connection URLs for PostgreSQL, MySQL and SQLite.
Mikail
Mikail2mo ago
Nope
RaphaelEtim
RaphaelEtim2mo ago
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...
Mikail
Mikail2mo ago
I am 100% sure I don't have a special charecter in my password
RaphaelEtim
RaphaelEtim2mo ago
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.