• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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