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

flejur 2 years 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 Tananaev 2 years ago

Are you sure you're using the right password?

odhiambo 2 years 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.

flejur 2 years ago

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

Anton Tananaev 2 years ago

What did you use?

flejur 2 years ago

User root Password root

Anton Tananaev 2 years ago

No, I meant before.

flejur 2 years ago

the root password for the vm