In this guide, you will learn how to safely upgrade the MariaDB database server to a newer version in the Ubuntu Linux distribution. Also, you will know how to check current MariaDB packages and remove the older version after upgrading the MariaDB server.
For any reason, you may have forgotten the MySQL root password and need to reset it. You can reset it if you have access to the server with sudo user privileges. Follow this simple guide and know how to reset MySQL root user password in Ubuntu.
In this guide, we use Ubuntu version 20.04, but it should also work with other similar Linux distributions such as future versions of Ubuntu and CentOS. Also, we cover the commands for resetting the root password of MariaDB as well.