OVIPanel Forums

At brightsteelcentre.com/, I just updated our MySQL server from v5.7 to v8.0.21.
The upgrade went well. Because our installation is binary, I need to add fresh v8.0 binaries to /usr/bin. After that, I execute the following command to verify the mysql version and login to mysql. I'm receiving the following error.

mysql —version
mysql: error when loading shared libraries: libcrypto.so.1.1: cannot open shared object file: There is no such file or directory

Note: I may login and view version information. ./mysql —version

CentOS Linux release 7.3.1611 (Core)

libaio-0.3.109-13.el7.x86 64 was installed.

ll /usr/lib64/libssl* /usr/lib64/libssl3.so /usr/lib64/libssl.so -> libssl.so.1.0.2k /usr/lib64/libssl.so.10 -> libssl.so.1.0.2k /usr/lib64/libssl.so.1.0.2k

Could someone kindly tell me what the problem is in my case?

3 major sql error help me to find.

[quote="brightsteel018" pid='3011' dateline='1664450937']
At brightsteelcentre.com/, I just updated our MySQL server from v5.7 to v8.0.21.
The upgrade went well. Because our installation is binary, I need to add fresh v8.0 binaries to /usr/bin. After that, I execute the following command to verify the mysql version and login to mysql. I'm receiving the following error.

mysql —version
mysql: error when loading shared libraries: libcrypto.so.1.1: cannot open shared object file: There is no such file or directory

Note: I may login and view version information. ./mysql —version

CentOS Linux release 7.3.1611 (Core)

libaio-0.3.109-13.el7.x86 64 was installed.

ll /usr/lib64/libssl* /usr/lib64/libssl3.so /usr/lib64/libssl.so -> libssl.so.1.0.2k /usr/lib64/libssl.so.10 -> libssl.so.1.0.2k /usr/lib64/libssl.so.1.0.2k

Could someone kindly tell me what the problem is in my case?
[/quote]

[quote="OviForumAdmin" pid='3036' dateline='1713852752']
[quote="brightsteel018" pid='3011' dateline='1664450937']
At brightsteelcentre.com/, I just updated our MySQL server from v5.7 to v8.0.21.
The upgrade went well. Because our installation is binary, I need to add fresh v8.0 binaries to /usr/bin. After that, I execute the following command to verify the mysql version and login to mysql. I'm receiving the following error.

mysql —version
mysql: error when loading shared libraries: libcrypto.so.1.1: cannot open shared object file: There is no such file or directory

Note: I may login and view version information. ./mysql —version

CentOS Linux release 7.3.1611 (Core)

libaio-0.3.109-13.el7.x86 64 was installed.

ll /usr/lib64/libssl* /usr/lib64/libssl3.so /usr/lib64/libssl.so -> libssl.so.1.0.2k /usr/lib64/libssl.so.10 -> libssl.so.1.0.2k /usr/lib64/libssl.so.1.0.2k

Could someone kindly tell me what the problem is in my case?
[/quote]
[/quote]

We're not using fresh binaries in CentOS 7. If you want to upgrade to MySQL 8.0, please execute the following command line in your server terminal:

sh /scripts/mysqlupgrade80.sh

Note: Before upgrading, make sure to take a backup of your local system for safety purposes.