OVIPanel Forums
MySQL v8.0: Unable to run MySQL binary - Printable Version

+- OVIPanel Forums (https://forum.ovipanel.in)
+-- Forum: User Control Panel (https://forum.ovipanel.in/forumdisplay.php?fid=11)
+--- Forum: User Control Panel (https://forum.ovipanel.in/forumdisplay.php?fid=12)
+--- Thread: MySQL v8.0: Unable to run MySQL binary (/showthread.php?tid=2047)



MySQL v8.0: Unable to run MySQL binary - brightsteel018 - 09-29-2022

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?


RE: MySQL v8.0: Unable to run MySQL binary - samhoppe - 04-18-2024

3 major sql error help me to find.


RE: MySQL v8.0: Unable to run MySQL binary - OviForumAdmin - 04-23-2024

[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]


RE: MySQL v8.0: Unable to run MySQL binary - OviForumAdmin - 04-23-2024

[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]


RE: MySQL v8.0: Unable to run MySQL binary - OviForumAdmin - 04-23-2024

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.