ER_NOT_SUPPORTED_AUTH_MODE when using MySQL driver

[gjsjohnmurray]

Originally posted by @nikashu3110 in #1066 (comment)

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

Originally posted by @nikashu3110 in #1066 (comment)

[gjsjohnmurray]

Related: #246

[gjsjohnmurray]

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

[nikashu3110]

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

[nikashu3110]

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

I tried what you said but error is showing up

[gjsjohnmurray]

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

[zayne-wang]

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

I tried what you said but error is showing up

I met the same issue with you before, but according to #1095 (comment), I changed my config to:

and then it works.

[gjsjohnmurray]

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