Getting an authentication failed error in the terminal even though my username and password are correct.
For Example, My user name is “root” and password is “mypassword” below is the database url for this
When I use this in my .env file and call it in the prisma schema file i’m getting the below error.
“Authentication failed against database server at
localhost, the provided database credentials for
root are not valid.”
But, I was able to create a db and test my connection using mysql in terminal, also using “Mysql ace” application.
I’m able to connect to my db.
Not sure why its not working inside the next.js project.