Joomla 2.5 and mysql 8

[corsair]

Hello,
Recently, my web server was updated to mysql 8 and my joomla 2.5 is not operating anymore.
I get: Database connection error (2): Could not connect to MySQL.
Any idea how to fix this?

[toivo]

I get: Database connection error (2): Could not connect to MySQL.
Any idea how to fix this?

Joomla 2.5 is probably expecting to use the database driver type 'mysql', defined in Global Configuration. The database driver type in PHP 8 is 'mysqli', which may not work in Joomla 2.5. Support for Joomla 2.5 ended in 2014 and the recommended version of PHP was 5.6.

Now is a good time to start planning to migrate the website to a supported version of Joomla 4.

[Per Yngve Berg]

mysqli shouldn't be a problem. It's older than J2.5, but there may be other incompatibilities.

[corsair]

Thanks for your responces,

I don't think php will be an issue, i am trying with php 5.6 (that was ok on previews server).
The issue i need to solve is the connection with mysql 8..

I know that it needs to upgrade but i want a temporary solution for now to be orperational..

[Per Yngve Berg]

You need to enable some legacy Authentication methods in mysql 8 to be able to connect old systems

[corsair]

Thanks for your responce, do you suggest to do it (enable legacy Authentication methods in mysql 8 server wide) ?
I think this will effect badly the server security..
Is there any other way to make it work?

[corsair]

Update.. I enabled legacy Authentication methods in mysql 8 but still no luck..
Same error..