download

wget https://www.openssl.org/source/openssl-3.1.4.tar.gz
tar -xvzf openssl-3.1.4.tar.gz
cd openssl-3.1.4
./Configure
make
make test
sudo make install
sudo ldconfig

add it

sudo echo /usr/local/lib/ > /etc/ld.so.conf.d/openssl.conf

load it

sudo ldconfig

CREATE USER IF NOT EXISTS 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'XXXX';

alter user 'root'@'127.0.0.1' identified with mysql_native_password by 'XXXX';

drop user zhangsan;

grant all privileges ON *.* TO 'root'@'127.0.0.1';