Configure MySQL root password on Ubuntu 18.04 and 20.04 LTS

In this video I will show you how to set up a MySQL root user password on Ubuntu 18.04 and 20.04.

On Ubuntu 18.04 and later, even if you set a MySQL root password using the mysql_secure_installation command, it will still allow you to log in as root without any password.

Orders :
UPDATE mysql.user SET plugin'mysql_native_password' WHERE user'root';
FLUSH PRIVILEGES;

Please take the opportunity to connect and share this video with your friends and family if you find it useful.