Prestashop 1.7 on MySQL8 front works, backoffice doesn't

[Decimal]

Howdy,

I had the need to move a prestashop 1.7 from a server with MySQL 5.7 to 8x.

The frontend works OK, but the backoffice doesn't, it complains about the new auth plugin, but the user is set with mysql_native_plugin (because it works in the front).

Any workarround to solve this without upgrade the plataform? I have no way to upgrade this ATM.

 

[Tue Jan 09 09:29:30.857512 2024] [proxy_fcgi:error] [pid 34217] [client 213.228.134.23:60711] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /home/hosting/website.pt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /home/hosting/website.pt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'neoeo', 'xxxxxxxxx', Array)\n#1 /home/hosting/website.pt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:host=loca...', 'neddeo', 'xxxxxx', Array)\n#2 /home/hosting/website.pt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'neo', 'xxxxxxxx', Array)\n#3 /home/hosting/website.pt/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(942): Doctrine\\DBAL\\Connection->connect()\n#4 /home/hosting/website.pt/src/PrestaShopBundle/Kernel/ModuleReposi...\n', referer: https://website.pt/admin/

[dinesh badrukhiya]

Hello @Decimal

Make sure you are using PHP 7.4 or higher version to work with mysql 8

Thanks.

[Decimal]

3 hours ago, dinesh badrukhiya said:

Hello @Decimal

Make sure you are using PHP 7.4 or higher version to work with mysql 8

Thanks.

Thanks it's not that.

just changed the default plugin for mysql8 to native