• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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