Solved mysql connect in terminal not working on an old LAMP app (1.4.0)

[msbt]

I have this ancient LAMP app with a shop in it that is finally going to be upgraded (I know I know, but it wouldn't work on >PHP7.2). After cloning the production image to test imports and exports, I wanted to jump on the mysql console to change the urls of the shop. But when I tried to connect, this is what happened:

mysql --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST} ${MYSQL_DATABASE} 
ERROR 2026 (HY000): SSL connection error: unknown error number

I reckon this is because of the new MYSQL version you installed, do you know of a trick to connect either way? Couldn't find a real solution...

[girish]

@msbt Right, the old one mysql CLI is not able to connect with new mysql 8. Best way is to upgrade to PHP 7.4 app.

If that's not an option:

• Grab the env vars from env | grep MYSQL
• Then use the web terminal of some other app that uses mysql (or just install lamp 7.4). Then in that web terminal, use the MYSQL vaules from above.

[msbt]

@girish perfect, worked like a charm! Just to be on the safe side: Will the old LAMP continue working or are there any breaking changes coming up soon?

[scooke]

@msbt Can you tell us what worked like a charm? Upgrading to PHP 7.4, or gradding the env vars?

[msbt]

@scooke using the terminal of a different app to connect to the LAMP 1.4.0 database

[girish]

@msbt the old LAMP app will be left as-is. So, no change to that in the foreseeable future.