I am trying to backup an Azure mySQL database, I understand I need to create a user account on @remotehost called user@localhost
However when I run the mysqldump command the user is coming back as user@publicIPaddress rather than user@localhost
I know I can create a user account user@publicIPaddress but as I do not have a static IP from my ISP so it will change periodically.
Is there a method for getting this to work with a single user account? I have a dynamic DNS setting so user@dynamicDNSname will always resolve the same place even when the IP address changes
However when I run the mysqldump command the user is coming back as user@publicIPaddress rather than user@localhost
Code:
Access denied for user 'backup'@'2.xxx.xxx.xxx' (using password: YES) when trying to connect
Is there a method for getting this to work with a single user account? I have a dynamic DNS setting so user@dynamicDNSname will always resolve the same place even when the IP address changes
Comment