Can't connect to MySQL server on (113 "No route to host")?

Question

MySQL

Please tell me, I create a user marked % (So that I can remotely connect), gave the user all the privileges also marked %, when connecting, it issues Can't connect to MySQL server on "1.1.1.1" (113 "No route to host" ) ?

Answer 1

No route to host
The operating system the client is running on has no idea where to send packets to reach this host.
It has nothing to do with the DBMS, it has to do with setting up a network. See the routing table and your network map.

Answer 2

tracert or traceroute (depending on your OS) to the database address. But something tells me that the error in the address - 1.1.1.1 is painfully strange.

Answer 3

server on "1.1.1.1" is most likely not on your subnet.
1) Check if the address is entered correctly (usually internal subnets have addresses like 10.0.0.x or 192.168.0.x, your option is not typical)
2) Check the IP and subnet mask on the machine from which the request is made, if the machines are located in different subnets, you need to configure routing, or, if they are not separated by routers / gateways, add the IP of the target subnet.
3) check the physical connection, there is a stupid cable break.