Posts: 1
Threads: 1
Joined: Sep 2022
Reputation:
0
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?
Posts: 1
Threads: 0
Joined: Apr 2024
Reputation:
0
3 major sql error help me to find.
Posts: 25
Threads: 3
Joined: Apr 2019
Reputation:
0
[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]
Posts: 25
Threads: 3
Joined: Apr 2019
Reputation:
0
[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]
Posts: 25
Threads: 3
Joined: Apr 2019
Reputation:
0
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.