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?
MYSQL upload to a remote DB
Moderator: Mattk
Re: MYSQL upload to a remote DB
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.
Mysql can hanlde logins from the console differently as fro remote. I guess your setup still has some remote blocking in it.