Tofandel
New Pleskian
- Server operating system version
- Ubuntu 20.04.6
- Plesk version and microupdate number
- 18.0.51
Hello,
I'm trying to run mariadb-dump from a plesk server to an external database server
I run this command
`mariadb-dump -h 255.255.255 -u user -p mytable` (with my desired ip address obviously)
But then I get this error
mariadb-dump: Got error: 1045: "Access denied for user 'user'@'127.0.0.1' (using password: YES)" when trying to connect
It's actually not 127.0.0.1 but my plesk server external ip, but not the one I'm trying to connect to
If I omit the host option, I get localhost instead
mariadb-dump: Got error: 1045: "Access denied for user 'user'@'localhost' (using password: YES)" when trying to connect
So why is mariadb-dump ignoring the host option on a plesk server? Is there any way to fix this
I'm trying to run mariadb-dump from a plesk server to an external database server
I run this command
`mariadb-dump -h 255.255.255 -u user -p mytable` (with my desired ip address obviously)
But then I get this error
mariadb-dump: Got error: 1045: "Access denied for user 'user'@'127.0.0.1' (using password: YES)" when trying to connect
It's actually not 127.0.0.1 but my plesk server external ip, but not the one I'm trying to connect to
If I omit the host option, I get localhost instead
mariadb-dump: Got error: 1045: "Access denied for user 'user'@'localhost' (using password: YES)" when trying to connect
So why is mariadb-dump ignoring the host option on a plesk server? Is there any way to fix this