How to access mysql base from an external network

Asked

Viewed 265 times

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 on an external network I get the following message:

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

The Mysql database is on a paid FTP server, it is not within the enterprise network, I do not have a VPN tunnel connected directly to it.

What kind of configuration do I change to connect on this basis?

android mysql delphi firemonkey

  • Try creating a new user to perform the access. Mysql has remote access for the user root blocked

1 answer

0


You can unlock remote access by root user in the following way:

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

Comment on the following line in your my.cnf

#bind-address = 127.0.0.1

restart the Mysql service

Browser other questions tagged android mysql delphi firemonkey

You are not signed in. Login or sign up in order to post.