cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Go to solution

Connect to my live server from local

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. 

1 REPLY 1
Highlighted
Helper VI Helper VI
Helper VI
Solution

Re: Connect to my live server from local

@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

~Jan Mykhail Hasselbring Web Administrator @ fullstackwebsolution.com