Cant connect remotely centos on mysql 5.7

Question

I've tested everything, and every possible way. I already disabled iptables, I did everything myself.

I gave joker permissions on all users and database in mysql.

And anyway, how can test https://cp.nationwarriors.com/ the error persists:

Fatal error connecting to mysql server. SQLSTATE [HY000] [2003] Can not connect to MySQL server on '177.87.231.218' (111)

in localhost I get it. I checked the door is normally open at https://www.yougetsignal.com/tools/open-ports/

Do you have your server binded to an external ip? Try bind-address=0.0.0.0 — Yvan Watchman, Mar 14 '18 at 12:16
I've done this process too, buddy. And it did not work either. :( — Leonardo Vanzo de Souza, Mar 14 '18 at 12:18
native of the centos, iptables. Look: http://prntscr.com/ir25ik — Leonardo Vanzo de Souza, Mar 14 '18 at 12:21
I would be grateful. Because I tried everything, and I can not find a logical solution: / I reinstalled mysql everything, did almost everything. — Leonardo Vanzo de Souza, Mar 14 '18 at 12:27
let's start from the network: does telnet work? do you receive "connection refused" or a password request? — senape, Mar 14 '18 at 13:21
ok, i tested it myself, and I am able to connect to your db, i.e. it's not a firewall/network problem. (i'm asked for username and password) at this point, i'm pretty sure it's a privilege problem. try looking at this answer: https://stackoverflow.com/questions/1420839/cant-connect-to-mysql-server-error-111 — senape, Mar 14 '18 at 13:31

score -1 · Accepted Answer · answered Mar 14 '18 at 14:32

-1

After a Teamviewer session and a few tests we've discovered that the problem is with the hosters firewall.

You can telnet from every location to the database server, except from the webserver.

answered Mar 14 '18 at 14:32

Yvan Watchman

Was solved. Yvan Watchman found the problem. Thank you, friend, for the help. – Leonardo Vanzo de Souza Mar 15 '18 at 17:34

1 Answers1