• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Mariadb-dump ignores external host

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
 
Okay I'm stupid, the error message indicates where the user is connecting from because of the mysql rules like (%, localhost etc)
 
Back
Top