If you can login with the OS user, you can do something like this:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;
I can log as root in my VPN, can I change the root password of the mysql database from there? I cannot log into mysql with root password, thanks for rhe help
Is there a reason you are asking this on the Traccar forum? There is a large amount of resources out there about MySQL. Google immediately gives me an answer to your exact question.
Hello there, there is a way to reset the mysql root password? I don't remember even putting one.
Thanks! Amazing job! I really appreciate all the hard effort pit into it