The command that I am running is:
user@user-Vostro-3558:~/Desktop/company/projects/saturdatTest$ adonis
migration:run
The error that I’m getting is:
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Handshake.Sequence._packetToError (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Handshake.ErrorPacket (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
at Protocol._parsePacket (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:375:28)
at addChunk (internal/streams/readable.js:290:12)
--------------------
at Protocol._enqueue (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Protocol.handshake (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/protocol/Protocol.js:51:23)
at Connection.connect (/home/user/Desktop/company/projects/saturdatTest/node_modules/mysql/lib/Connection.js:116:18)
at /home/user/Desktop/company/projects/saturdatTest/node_modules/knex/lib/dialects/mysql/index.js:68:18
at new Promise (<anonymous>)
at Client_MySQL.acquireRawConnection (/home/user/Desktop/company/projects/saturdatTest/node_modules/knex/lib/dialects/mysql/index.js:63:12)
at create (/home/user/Desktop/company/projects/saturdatTest/node_modules/knex/lib/client.js:290:39) {
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
}
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi there,
As the error indicates that the authentication mode is not supported, what I could suggest is to change your authentication mode from caching_sha2_password to mysql_native_password.
You can follow the steps on how to do that here:
Let me know how it goes! Regards, Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.