MYSQL upload to a remote DB

This section covers the Meteobridge PRO units exclusively

Moderator: Mattk

Post Reply
fartaritx
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Tue Apr 17, 2018 6:26 am

MYSQL upload to a remote DB

Post by fartaritx » Tue Apr 17, 2018 6:41 am

When trying to upload to a database that is on a remote server (outside the LAN in which the MB is) I get the error message:
"Error: Failed to connect to MYSQL database: Access denied for user ' p4XXX33@146.xx.xxx.111' (using password: YES) (no more tries):"

Apparently the logon request being passed to MySQL is username@'localIP', as opposed to 'username'@'hostIP'.

I can log into the remote database using MySQL Workbench, so there's nothing wrong with regard to the remote servers privileges.

Is this a software problem or do I need to configure the service differently?

User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 5281
Joined: Mon Oct 01, 2007 10:51 pm

Re: MYSQL upload to a remote DB

Post by admin » Sun Apr 22, 2018 6:58 pm

This has to be solved within the setup of the mysql server.
Mysql can hanlde logins from the console differently as fro remote. I guess your setup still has some remote blocking in it.

Post Reply