Connect to my live server from local

[jbdatuin25]

Good day, I am facing a problem when I try to access my online database from local windows form app, it always shows this error message Access denied for user 'xxxxx'@'xxx.xx.xxx.xx' (using password: YES) even I write the correct combination of server/user/pass/database name.

I also try to access my online database using Mysql Workbench but it also show a error message of access denied. Thank you. 

[JHasselbring · Accepted solution]

@jbdatuin25 

You need to either allow your user to login remotely or create a specific user that is allowed to log in remotely.

By default (which is good), MySQL only allow local connections to prevent malicious users from brute forcing your database.

Here's some more info: https://devdocs.magento.com/guides/v2.3/install-gde/prereq/mysql_remote.html