search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.44k stars 291 forks source link

ER_NOT_SUPPORTED_AUTH_MODE when using MySQL driver #1095

Open gjsjohnmurray opened 1 year ago

gjsjohnmurray commented 1 year ago

Originally posted by @nikashu3110 in https://github.com/mtxr/vscode-sqltools/issues/1066#issuecomment-1399203004 image

I am unable to solve this problem. can someone help me with this please.

Originally posted by @nikashu3110 in https://github.com/mtxr/vscode-sqltools/issues/1066#issuecomment-1399203004

gjsjohnmurray commented 1 year ago

Related: #246

gjsjohnmurray commented 1 year ago

Did you try the advice about ER_NOT_SUPPORTED_AUTH_MODE at https://vscode-sqltools.mteixeira.dev/en/drivers/my-sql/ ?

nikashu3110 commented 1 year ago

I am learning MySQL for the first time, so I am not sure if I understand this! I am following a youtube tutorial of how to use mysql in vscode. but for them the SOL_driver_credential option does not show up but it shows up for me

image

nikashu3110 commented 1 year ago

Did you try the advice about ER_NOT_SUPPORTED_AUTH_MODE at https://vscode-sqltools.mteixeira.dev/en/drivers/my-sql/ ?

image

I tried what you said but error is showing up

gjsjohnmurray commented 1 year ago

Please try entering an integer value for the "Connection Timeout" field.

zayne-wang commented 1 year ago

Did you try the advice about ER_NOT_SUPPORTED_AUTH_MODE at https://vscode-sqltools.mteixeira.dev/en/drivers/my-sql/ ?

image

I tried what you said but error is showing up

I met the same issue with you before, but according to https://github.com/mtxr/vscode-sqltools/issues/1095#issuecomment-1399206049, I changed my config to:

image

and then it works.

gjsjohnmurray commented 1 year ago

@nikashu3110 did the advice from @mat-wang help you resolve this? If yes, please close the issue.