I have a server hosted by digital ocean with mysql installed. The password credential for the mysql root user is located in the root folder.
However, entering the password after
mysql -u root -p leads to
sorry, try again..
Funnily, if I do
sudo mysql -u root, it'll log in automatically. I'm slightly uncomfortable with how easy it went.
I dont recall tampering with the root credentials. What is the root of the issue? How should things be reconfigured? I'm scared to change anything at risk of losing root access.