No Mysql Backup mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

flejur3 months ago

Hello,

i have installed traccar with https://www.traccar.org/install-digitalocean/

When i try a backup mysq: root@gps02:~# mysqldump -u root -h localhost -p traccar > traccar.sql
Enter password:

i receive this error:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

i can login on the virtual server with root, the login on mysql is not working

How can I backup the Traccar Database?

Thank You?

Anton Tananaev3 months ago

Are you sure you're using the right password?

odhiambo3 months ago

If, when you installed MySQL, you did not secure it, then the root password is possibly blank!
If you secured it, then use the correct password.

flejur3 months ago

I have found the error. The password is root. Many thanks for your help!

Anton Tananaev3 months ago

What did you use?

flejur3 months ago

User root Password root

Anton Tananaev3 months ago

No, I meant before.

flejur3 months ago

the root password for the vm