Mysql root password

Segads2 years ago

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

Anton Tananaev2 years ago

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;
Segads2 years ago

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

Anton Tananaev2 years ago

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.