Magento 2.4.5 MySql 8 Auto Install Error - ER_NOT_SUPPORTED_AUTH_MODE

[gaiterjones]

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

[patrykbura]

Hey it looks like this is a known and open issue in mysql: mysqljs/mysql#1507

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

[gaiterjones]

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?