SQL statement: "UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root';" fails under MySQL 8

[EliasGabrielsson]

Nextcloud 21 requires MySQL 8 which have been solved in this patch: freenas/iocage-ix-plugins@66c2a15#diff-dc0257b7d5f992ca8b298c39c494585a212f9a18472c316957e41e37769332c4

However the current installation script fails when using version 8 of MySQL.
The statement UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root'; fails, found here:

iocage-plugin-nextcloud/post_install.sh

Line 85 in ff30b09

UPDATE mysql.user SET Password=PASSWORD('${PASS}') WHERE User='root';

[EliasGabrielsson]

https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/

[KSEGIT]

I'm wondering can I somehow install this plugin with this fix on my nas? or do I need to wait until your commit is pushed to master?

[Cooper-Dale]

unable to finish instalation, I hope the reason is the same
on NextCloud setup page I have:
Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

[xilmen]

unable to finish instalation, I hope the reason is the same
on NextCloud setup page I have:
Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Hi, you can follow https://help.nextcloud.com/t/nextcloud-error-on-truenas/115791/7 :) (works for me :))