Answer the question
In order to leave comments, you need to log in
How to fix Can't connect to MySQL server on 'xxxx' (110) on VPS?
tell me how to solve the problem I'm
setting up a VPS for the first time, I can't deal with this problem .....
I made a new user for mysql gave him GRAND rights to all databases and all IP
GRANT ALL PRIVILEGES ON *.* TO [email protected]'%' IDENTIFIED BY 'pass' WITH GRANT OPTION
In the settings /etc/mysql/my.cnf
bind-address = xxxx changed to the connection needed
before this was only possible locally (by the way, how to make it work both locally and remotely for one user)
#skip-external -locking commented out
Result: WorkBench connects without problems and executes requests, and from my working site I check requests - writes:
Can't connect to MySQL server on 'xxxx' (110)
Answer the question
In order to leave comments, you need to log in
Do on the server with mysql:
iptables -L -n
netstat -npl | grep 3306
iptables -L -n
telnet x.x.x.x 3306
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question