How to access mysql base from an external network

Navigation
0

I have an application, on Android with MySQL database, that works perfectly within a specific network. But when trying to access this same base in an external network I get the following message:

  

28000Acess Denied for user 'root' @ 'my ip' (using password: YES)

The MySQL database is on a paid FTP server, it is not inside the corporate network, I do not have a VPN tunnel connected directly to it.

What kind of setting do I change to connect to this base?

    
asked by anonymous 03.08.2018 / 19:22

1 answer

0

You can unlock remote access by the root user as follows: 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

Comment the following line on your my.cnf 

#bind-address = 127.0.0.1

restart the MySQL service

    
03.08.2018 / 19:36
App Bar does not appear Call function in Form [duplicate]