VPS failed connecting the database
#1

Hello. I recently bought VPS, configured, etc and now, then I start server using nohup ./samp03svr & (I'm using Debian 9), server log prints this: connection error (Code #2003): Can't connect to MySQL server on '185.34.52.164' (111). Maybe someone know how to solve this problem? I tried everything, reinstalled debian and configuration few times...
Reply
#2

First result in G00gle with the term 'mysql error 111' will show you this: https://stackoverflow.com/questions/...rver-error-111

Quote:

It probably means that your MySQL server is only listening the localhost interface.

If you have lines like this :
Код:
skip-networking
bind-address = 127.0.0.1
In your my.cnf configuration file, you should comment them (add a # at the beginning of the lines), and restart MySQL.

Код:
sudo service mysql restart
Of course, to do this, you must be the administrator of the server.

Please, next time do some research and then post.
Reply
#3

Quote:
Originally Posted by bgedition
Посмотреть сообщение
First result in G00gle with the term 'mysql error 111' will show you this: https://stackoverflow.com/questions/...rver-error-111



Please, next time do some research and then post.
Thanks
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)