MySQL 8 authentication protocol problem

[sajaddp]

Hi,
I using Mysql 8 and followed the instructions in https://docs.adonisjs.com/guides/database/introduction.
But I got an error with this message:

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

What is your suggestion to solve this issue?

[sajaddp]

Solution:
Install mysql2 with npm i -S mysql2 and in database.ts change client: 'mysql' to client: 'mysql2'

[matondomp]

it was also my problams, i used this solution and works well

[feliperafaelbarbosa]

Thanks, this worked for me. 😄