Flowise icon indicating copy to clipboard operation
Flowise copied to clipboard
Published 1 day ago • verified publisher icon FlowiseAI

[BUG] connect mysql error

Open longkeyy opened this issue 1 year ago • 5 comments

To Reproduce Steps to reproduce the behavior:

  1. Go to new flow
  2. Click on add SqlDatabaseChain
  3. Database Mysql
  4. Connection: root:[email protected]:3306/test
  5. chat: What data I have? 6.see error.

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Setup

  • Installation npx flowise start
  • Flowise Version [1.15.0]
  • OS: macOS
  • Browser chrome

Additional context Add any other context about the problem here.

Error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

longkeyy avatar Feb 21 '24 19:02 longkeyy

I had the same problem

DigYang avatar Mar 08 '24 10:03 DigYang

same problem

adhiiisetiawan avatar Mar 13 '24 07:03 adhiiisetiawan

I've created a PR to fix this issue. It works well in my server.

zhengcan avatar Mar 15 '24 05:03 zhengcan

I changed how the sql server plug-in is connected, caching_sha2_password-> mysql_native_password. It works for me

DigYang avatar Mar 15 '24 05:03 DigYang

hi @DigYang where to setting it?

adhiiisetiawan avatar Mar 15 '24 06:03 adhiiisetiawan

i used the tool Navicat and set it in the user menu.

DigYang avatar Mar 25 '24 03:03 DigYang