Page 1 of 1

MYSQL upload to a remote DB

Posted: Tue Apr 17, 2018 6:41 am
by fartaritx
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?

Re: MYSQL upload to a remote DB

Posted: Sun Apr 22, 2018 6:58 pm
by admin
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.