How to reset the root password for MySQL?
There is mysql service installed to server, but I don´t remember the root password. Is it possible to reset it?
You will want to stop your MySQL service first:
sudo systemctl stop mysql.service
To go through the initial configuration for setting you your MySQL password:
sudo dpkg-reconfigure mysql-server-5.5