How to correctly set up mysql on the server for remote access?

Question

linux

Installed mysql-server, mysql-client, php-mysql/ on VDS
Changed bind-address to 0.0.0.0
Created user GRANT ALL PRIVILEGES ON db.* TO [email protected]'%' IDENTIFIED BY 'xxx';

But I can't remotely connect to the database. How to get remote access to the database on vds?

Answer 1

ports checked?
you can login mysql -u root -p
and see
show variables like 'port';
if you have iptables on the server then
iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

Answer 2

Apparently, there is a problem with the firewall, or something else, because of which connections on port 3306 do not reach the server.
As part of the diagnostics, try temporarily disabling the firewall and trying to connect again. Also provide the output of a connection attempt from a remote server. What error is being thrown?
As a check for port availability, try scanning the delivery of udp packets to the server. To do this, on the server where you are trying to connect remotely, enter the packet capture command: tcpdump -i any port 3306. Then, on the server from which the remote connection is made, start scanning the port of the first server: nc -vnzu IP-address_of the first server 3306. Then on the first server in the console the output "tcpdump" should appear with the address of the second server, which will mean that the packets reach correctly and there should be no problems with a remote connection