C
C
Carry2014-09-04 10:09:37
MySQL
Carry, 2014-09-04 10:09:37

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

1 answer(s)
A
Anton Solomonov, 2014-09-04
@carryx

Do on the server with mysql:

iptables -L -n
netstat -npl | grep 3306

On the server with the working site, do:
iptables -L -n
telnet x.x.x.x 3306

You have already done [email protected]' % '.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question