magento2-alpaca-theme icon indicating copy to clipboard operation
magento2-alpaca-theme copied to clipboard

Magento 2.4.5 MySql 8 Auto Install Error - ER_NOT_SUPPORTED_AUTH_MODE

Open gaiterjones opened this issue 2 years ago • 2 comments

Seeing the following error after running npx @snowdog/create-alpaca-theme on M2.4.5 with MySQL 8

? Update database with essential Alpaca tables? (Recommended) Yes | ██████████████████████████░░░░ | 85% || Running database queries... Database connection error: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

gaiterjones avatar Sep 09 '22 09:09 gaiterjones

Hey it looks like this is a known and open issue in mysql: https://github.com/mysqljs/mysql/issues/1507

Have you tried: https://stackoverflow.com/a/50131831/18890929 ?

patrykbura avatar Sep 20 '22 12:09 patrykbura

I did see that but had assumed the install process was using db access credentials derived from Magento and did not want to change that user. According to that info node has it's own db access, so I would rather create a new mysql user for node. Is that possible? Where are the db access credentials configured?

gaiterjones avatar Sep 20 '22 15:09 gaiterjones