Authentication failed against database server at `ip external`, the provided database credentials for `user` are not valid.

See original GitHub issue

Bug description

Authentication failed against database server at ip external, the provided database credentials for user are not valid.

ps: npx prisma studio connect! ps: all external clients connect with same user! ps: works normally on windows!

How to reproduce

const results = await prisma.mytable.findMany();
console.log(results);

Expected behavior

log results only

Prisma information

schema.prsima:

datasource db {
  provider = "mysql"
  url      = "mysql://user:password@ip:3306/mydb"
}

Environment & setup

  • OS: MacOs Monterei (M1)
  • Database: MySql
  • Node.js version: 14.17.0

Prisma Version

prisma                : 2.30.3
@prisma/client        : 3.5.0
Current platform      : darwin
Query Engine (Binary) : query-engine b8c35d44de987a9691890b3ddf3e2e7effb9bf20 (at node_modules/@prisma/engines/query-engine-darwin)
Migration Engine      : migration-engine-cli b8c35d44de987a9691890b3ddf3e2e7effb9bf20 (at node_modules/@prisma/engines/migration-engine-darwin)
Introspection Engine  : introspection-core b8c35d44de987a9691890b3ddf3e2e7effb9bf20 (at node_modules/@prisma/engines/introspection-engine-darwin)
Format Binary         : prisma-fmt b8c35d44de987a9691890b3ddf3e2e7effb9bf20 (at node_modules/@prisma/engines/prisma-fmt-darwin)
Default Engines Hash  : b8c35d44de987a9691890b3ddf3e2e7effb9bf20
Studio                : 0.423.03.5.0

Issue Analytics

  • State:closed
  • Created 2 years ago
  • Comments:5 (4 by maintainers)

github_iconTop GitHub Comments

1reaction
pantharshit00commented, Nov 29, 2021

Also, worth mentioning that you are using quite a old version of Prisma here so you should try again with the latest version first.

0reactions
pantharshit00commented, Jun 2, 2022

I am going to close this as its been 3 months now and there is no activity here from original author.

Please reply if you want us to take another look.

Read more comments on GitHub >

github_iconTop Results From Across the Web

p1000 authentication failed against database server #8925
I'm trying to use docker, postgres and prisma together but I'm running into an error. I have a docker-compose.yml file: version: '3.8' services: ......
Read more >
Prisma cannot authenticate database server - Stack Overflow
P1000 : Authentication failed against database server at 127.0.0.1 , the provided database credentials for db_user` are not valid.
Read more >
please make sure your database server is running at ...
Error: P1000 : Authentication failed against database server at `localhost`, the provided database credentials for `johndoe` are not valid.
Read more >
Troubleshooting for RDS Proxy - AWS Documentation
This command reports failure if you're not in the same VPC as the proxy and the associated database. You might be able to...
Read more >
Error message when you connect to an instance of SQL Server
To work around this behavior, specify a valid, available database in the connection string. To prevent the error when the user's default database...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found