VPS failed connecting the database

VPS failed connecting the database - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: VPS failed connecting the database (/showthread.php?tid=664736)

VPS failed connecting the database - Marshas - 09.03.2019

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...

Re: VPS failed connecting the database - bgedition - 09.03.2019

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.

Re: VPS failed connecting the database - Marshas - 10.03.2019

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