How to solve mysql secure installation problem

As of July 2022, an error will occur when you run the mysql_secure_installation script without some further configuration. The reason is that this script will attempt to set a password for the installation’s root MySQL account but, by default on Ubuntu installations, this account is not configured to connect using a password.

Prior to July 2022, this script would silently fail after attempting to set the root account password and continue on with the rest of the prompts.

To solve this problem, you just need to follow the steps in this video

Commands Used
sudo apt install mysql-server
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
exit
sudo mysql_secure_installation

Useful Links
VPS/VDS - https://www.mivocloud.com/

Видео How to solve mysql secure installation problem канала MivoCloud