4
gitpush
6y

I don't understand this:
xtrabackup --backup --datadir=/Path/To/Database/ --target-dir=/Path/To/DBBackup/ --host=172.25.0.51 --port=3306 --user=backup --password=...

When I execute it out put says:
Access denied for user 'backup'@'172.25.0.1'

Why is it using user@GATEWAY instead of user@HOST?

Comments
  • 1
    @Linux you told me about percona, you should help me on this :P

    Joking man, but it would be nice to understand why this happened.

    XtraBackup is installed directly on server (without any config from my side) While MySQL is running inside docker
  • 2
    I guess you have to check the grants for the user 'backup'@'%' :)
  • 0
    @Linux it's a Dev server I gave it All privilege on *.*
  • 1
    @gitpush
    Yeah but the user is probably 'backup'@'localhost'
  • 0
    @Linux hmm.. let me check I might have that user created, thanks man 😀
  • 1
    @gitpush
    Use '%' instead of 'localhost' :)
  • 1
    @Linux noted thanks 😀😀
Add Comment